what is the main advantage of unconnected lookup

Answer Posted / praveen sh

If the same lookup table is used multiple times in the same
mapping, then it is better to go for un connected lookup.
Doing so we save cache memory and enhence performence

Is This Answer Correct ?    15 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe data concatenation?

561


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1689


is it possible to index the data in cache of lkp transformation ?

1513


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

6742


what is the size of your data warehousing?

1661






What is Cognos script editor?

3778


What is the maplet?

609


What is native users?

711


Explain the different kinds of facts.

554


What are the uses of etl tools?

633


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

606


What is workflow manager?

562


How does a rank transform differ from aggregator transform functions max and min?

661


permutations of mapplet

2025


what are 3 tech challenges/ common issues you face?

1875