Input record and output table schemas are not compatible

rajeshgundala · Post by **rajeshgundala** » Tue Sep 15, 2009 1:24 am

Hi,
I am populating a Teradata table from another one. I had used Teradata enterprise stage. For one column i had defined it with default value as 0.But the actual datatype of this column is decimal(18,0).
When i run the job, i am get this error:Input record and output table schemas are not compatible.

In target Teradata enterprise stage, i used write mode option as : Truncate. when i change this option to replace, the target table is getting created as data type Byteint. But when i change the default value for that column to 0.0, the datatype is Decimal(2,1)

Could some one pls help me to solve this issue.

Regards

keshav0307 · Post by **keshav0307** » Wed Sep 16, 2009 3:27 am

do you have a trnaformer stage in between the source and target?