Converting and

[Ratan Babu N]

Hi All,

My source field consists of Char field. I have to look up on the Varchar field and I will load that field as Varchar. For that there is a need to convert the source char field to Varchar and then trim the white spaces.
Can I do that in Modify stage or any other stage other than Transformer stage. If so how to do? Plz Clarify.

[ray.wurlod]

In the Chapter in the Modify stage in the Parallel Job Developer's Guide is a table showing what data type conversions can happen automatically and which ones require a function. Read that first. Then read through the available data type conversion and cast functions.