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 client want us to covert that "P" to 1 and "T" to 2 and load that to table. Earlier we were just passing T and P to table.
Please let me how this can be achieved. I'll really appreciate, If someone can provide exact code to perform this, as I'm new to Datastage
Convert Char to Integer in transformer
Moderators: chulett, rschirm, roy
Convert Char to Integer in transformer
Regards,
Arvind
Arvind
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: