when will we use unconnected & connected lookup? How it
will effect on the performance of mapping?
Answer Posted / jeevan kumar medapati
if u want to perform look up on less values then we go for
connected lkp
if u want to perform look up from more than one table then
we go for un connected lkp
in ur source u have more date columns then we should go for
unconnected lkp.
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Define the various join types of joiner transformation?
Explain the types of lookup transformation?
What is the use of an aggregator cache file?
What is substr in informatica?
what is $$$$?
How to update source definition?
Partition, what happens if the specified key range is shorter and longer
What are the types of schemas we have in data warehouse and what are the difference between them?
Implementation methodology
How can we use batches?
According to his methodology what all you need before you build a datawarehouse
What are the different types of olap? Give an example?
explan ur project architecture?
What is the need for an etl tool?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?