when will we go for unconnected lookup transformation in
Informatica?
Answer Posted / g. manthiramoorthy
1. Calling the same lookup multiple times in one mapping
2. Testing the results of a lookup in an expression
3. Filtering rows based on the lookup results
4. Marking rows for update based on the result of a lookup,
such as updating slowly changing dimension tables
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What does role playing dimension mean?
How is union transformation utilized?
How does the aggregator transformation handle null values?
How can we delete duplicate rows from flat files?
What are the types of caches in lookup?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is an expression transformation in informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the types of presistent cache in look up tr.
Can we create a node as a gateway node and the same node can be assigned to a grid?
What are pre and post-session shell commands?
What are the main issues while working with flat files as source and as targets ?
Write the unconnected lookup syntax and how to return more than one column.
How many transformations can be used in mapplets.