Convert Char to Integer in transformer

[arvindj]

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

[ppalka]

The easiest way is to use transformer stage and use such derivation on output column:
if Emp_type='P' then 1 else if Emp_type='T' then 2 else -1

[priyadarshikunal]

or you can use convert function to do character by character replacement. Read the documentation if you don't know how to use this function.

[ray.wurlod]

Or you could use a lookup in a Modify stage.