DSXchange

Job is using the schema file to load the data.
In the schema the field is defined as TIME in the below format.
XYZ_TIME:nullable Time {time_format='%hh%nn%ss'}

Source is sending the time in Decimal (Decimal 7,0) format. We are reading the data using the Schema file (Input = ASCII) and trying to load into Teradata table. We would like load the time field with proper time format. Field defination in Schema: XYZ_TIME:nullable Time {time_format='%hh%nn%ss'} In...

Hi Ray, tried 'read as EBCDIC' in the sequential stage without any luck... There is an existing production job which converts the file from EBCDIC to ASCII. Due to some constraint, Job is using column importer instead of CFF to read the EBCDIC file (input is a 'multiple redefine layout') and splitti...