Datatype conversion in lookup transformation

Question

I have lookup table with one string column and input column from source qualifier is decimal data type. I need to use these two columns in lkp condition. While doing this it is throwing invalid datatype error. So here i need to convert input lookup column datatype. Is anyother way to get this done

Answer 1

Convert your input column in another column in an expression using the function below: TO_CHAR(Your_Column), then link this new column to your lookup.

Answer 2

Have you tried to add an Expression transformation that will first transform your input to string then do the lookup after the Exptrans. Try this

Answer 3

The datatypes of the 2 columns need to be the same, otherwise how can you expect there to be any matches in the lookup? You can either convert the string to a decimal or the decimal to a string, whichever is easier