varchar to char issue in fixed length target sequential file

[HemaV]

Hi All,

My source is coming from oracle database and my target is Fixed length sequential file.

my source column col1 is varchar(60) and target column will be char(60).
i'm getting NULL values from source and my job is aborting.

In SEQ stage, under format tab i gave in NULL FIELD VALUE=' ' in Field defaults. Record level earlier it was FIXED but not i removed that option also. still records are getting reject.

Thanks,

[ray.wurlod]

For a fixed-width format sequential file, the Null Field Value must have the same number of characters as is specfied as the field width.

And you should (can) not have VarChar data types in a fixed-width file.