Teradata Interview Question:

Can we have an unconnected lkp to lookup a DB2 record against a Teradata record? doesnt seem to work. I could be wrong.

Submitted by: Administrator

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.
Submitted by: Administrator