dg

• Jul 21st, 2006

 

Yes we can ..but some times we need to check the value which lookup is returning .....like it happens in teradata if we are having lookup on varchar column and record is coming from source system it never works because when informatica creates cache from there it adds space to the values.so we always have to use ltrim(rtrim)) function in lookup query.

Thanks

DG