A field, XXX_ID is not extracted the right way.
Example: we should get XXX_ID = B0061
but we got B0061 2010 (tab between B0061 and 2010)
2010 is part of the date in the source flat file. I checked quickly the job, and the delimiter is in fac a tabulation.
Cause and Solution -
Actually the XXX_ID is defined as a NVarchar(10) field, and so Datastage is reading 10 characters into that field, assuming it to be the last field of the record.. So, we need to define the complete format on the Columns tab, so that Datastage knows that there is another field after the XXX_ID field and therefore consider the delimiter. So, we need to define the column DATE_EXPORT too on the Input Columns tab of the Sequential File.
Example: we should get XXX_ID = B0061
but we got B0061 2010 (tab between B0061 and 2010)
2010 is part of the date in the source flat file. I checked quickly the job, and the delimiter is in fac a tabulation.
Cause and Solution -
Actually the XXX_ID is defined as a NVarchar(10) field, and so Datastage is reading 10 characters into that field, assuming it to be the last field of the record.. So, we need to define the complete format on the Columns tab, so that Datastage knows that there is another field after the XXX_ID field and therefore consider the delimiter. So, we need to define the column DATE_EXPORT too on the Input Columns tab of the Sequential File.
Tags
Datastage