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
Briefly explain the aggregator transformation?
What is informatica? Why do we need it?
What is Cognos script editor?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Where is metadata stored?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Is it possible to revert a global repository to local one and why?
What is rank index in rank transformation?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How do you load alternate records into different tables through mapping flow?
What is an aggregator transformation?
How to handle decimal places while importing a flatfile into informatica?
How to elaborate tracing level?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is informatica powercenter repository?