Problem in conversion
Posted: Wed Sep 05, 2007 12:18 am
Hi all,
went through the forms pertaining to this but did not get much help. i am trying to load a file with four columns into a table. the mapping is like
went through the forms pertaining to this but did not get much help. i am trying to load a file with four columns into a table. the mapping is like
Code: Select all
source_field: target_field
SRC_CUSIP_ID (int 10) SRC_CUSIP_ID ( integer 4)
PSTNBalance (dec 17) PSTNBalance ( dec 8)
PSTNShareQuantity (int 4) PSTNShareQuantity ( int 4)
CUSIP_ID (int 10) CUSIP_ID ( int 4)
its giving me error on the third field when i use this in the modify stage
Specification= PSTNShareQuantity:int8= PSTNShareQuantity
error:
Teradata_Enterprise_2: Type mismatch for field 'SRC_CUSIP_ID'. Fatal error.
Type mismatch for field 'PSTNShareQuantity'. Fatal error.
Type mismatch for field 'PSTNBalance'. Fatal error.
how can you overcome this problem ? should it not just trim the records when i do the conversion ?