Teradata Enterprise -Error message
Posted: Mon Jan 17, 2011 6:06 am
I have a job having source as Oracle and Target as Teradata Enterprise stage.We are extracting data from oracle and loading data into TD using TD EE stage as Target.
In Oracle one column INDV_ID has datatype as Number(9) and same column in Teradata has datatype as Decimal(9,0).
We are reading this column as varchar(20) and doing transformation in transformer using StringtoDecimal function and trying to load it in Target TDEE stage,but we are getting below error message:-
Teradata_Enterprise_Target: Error when checking operator: Type
mismatch for field 'INDV_ID'. Fatal error.
It seems to be a but in DS for me,i need your help to resovle this issue.
Regards
Prasoon
In Oracle one column INDV_ID has datatype as Number(9) and same column in Teradata has datatype as Decimal(9,0).
We are reading this column as varchar(20) and doing transformation in transformer using StringtoDecimal function and trying to load it in Target TDEE stage,but we are getting below error message:-
Teradata_Enterprise_Target: Error when checking operator: Type
mismatch for field 'INDV_ID'. Fatal error.
It seems to be a but in DS for me,i need your help to resovle this issue.
Regards
Prasoon