Teradata Question: Download Teradata PDF
Can we have an unconnected lkp to lookup a DB2 record against a Teradata record? doesnt seem to work. I could be wrong.
Answer:
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.
| Previous Question | Next Question |
| What is the difference between start schma and Fsldm? | What is stored procedure in Teradata? |