DSXchange

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.

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.