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
Input record and output table schemas are not compatible
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 10
- Joined: Tue Apr 22, 2008 4:50 am
Input record and output table schemas are not compatible
Rajesh Gundala
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia