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
What are different types of transformations available in informatica?
permutations of mapplet
What you know about transaction control transformation?
Suppose we do not group by on any ports of the aggregator what will be the output?
Define mapplet?
Reusable transformation and shortcut differences
Mention some types of transformation?
Which transformation should we use to normalise the COBOL and relational sources?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are the types of schemas we have in data warehouse and what are the difference between them?
Explain the different dimensions.
What is an aggregator transformation?
How can you increase the performance in joiner transformation?
How to differentiate between the active and passive transformations?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?