Typemismathch

irajasekharhexa · Post by **irajasekharhexa** » Tue Jul 03, 2007 12:08 pm

Hi I am trying to populate some data from a dataset to teradata table.

In the dataset there is a filed 'AUDIT_TIMESTAMP' with the type Timestamp.
But at the Teradata the field is AUDIT_TIMESTAMP Timestamp 26(Length) 6(Scale) is taken.

After running the Job I am getting the following error.

CorrectedValuesl1: Type mismatch for field 'AUDIT_TIMESTAMP'. Fatal error.
Input record and output table schemas are not compatible.
Cannot prepare target table.

Is the above error is because of Length and Scale is mismathced? in bothe source and target?

Can any one pls clarify.

Regds

ray.wurlod · Post by **ray.wurlod** » Tue Jul 03, 2007 1:13 pm

Try experimenting with Length and Scale. Try extracting the timestamp from the Data Set, and loading into Teradata, with no Precision or Scale. Try using a test table with Timestamp(19).

irajasekharhexa · Post by **irajasekharhexa** » Wed Jul 04, 2007 7:56 am

Teradata is not allowing to change the timestamp to the lenght of 19.

Changed as the Varchar type. Now job is runnig fine

Thanks