when will we go for unconnected lookup transformation in
Informatica?
Answer Posted / naresh
If we want to use multiple times in same mapping you can go
for un-connected lookup and It depends on how much data
your processing.
performance wise unconnected lookup is better because its
like reusable one and it will lookup the values only the
condition meet the criteria.
1. It will return only one value
2. It will act as static cache
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is decode in informatica?
What is a code page?
Partition, what happens if the specified key range is shorter and longer
How an expression transformation differs from aggregator transformation?
Explain lookup transformation is active in informatica
What are the advantages of informatica?
Why do we need informatica?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
How can you generate reports in informatica?
Explain sessions?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Informatica settings are available in which file?
What is aggregate cache in aggregator transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is lookup transformation?