Lookup Will work or not

[jpraveen]

Hi All,

Will the lookup will work if the one of the datatype in Char and it is unicode.

suppose my primary source having one column P1 of datatye varchar 25 (not unicode) and reference having one coulmn R1 of datatype Char 25(unicode), if i am going to lookup these P1 and R1 , will Lookup work in Datastage 8.5

One of my friend said it will work in DS 7.5 , but in 8.5 it won't work, can you specify the reason.

Thanks in advance

[srinivas.g]

It will work but in reference since data type is char(25) and it will read only char=25 records only.