LOOKUP Condition is nothing but a Join condition?
What type of join condition it,by default ?
Using the LookUP Condition How many types of relational
conditions we can make ?
Answer Posted / krithi
Using the Lookup Condition , we can only compare values
between two columns. If the data matches it returns the
default value and NULL if the data doesn't match.
We can compare using the following operators :
1) =
2)!=
3)< or <=
4)> or >=
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Explain the use of aggregator cache file?
What is domain in terms of informatica?
Differences between connected and unconnected lookup?
Differentiate between a repository server and a powerhouse?
What does role playing dimension mean?
What are the types of presistent cache in look up tr.
What is meant by active and passive transformation?
What does cheating measurement mean?
Explain the shared cache and re-cache?
What is Data Caches size?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What do think which one is the better joiner or look up?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Difference between Target-based loading and constraint-based loading?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab