Search found 1 match
- Thu Nov 06, 2014 4:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Convert Char to Integer in transformer
- Replies: 3
- Views: 3060
Convert Char to Integer in transformer
Hi All, I have a job in our project. Job reads a flat file into sequential file and load that to a table. Transformer stage is used in between. Input file has a column of Char(1), Emp_type and incoming values can be "P" or "T" only, for Permanent and Temporary employees. Now clie...