what is the main advantage of unconnected lookup

Answers were Sorted based on User's Feedback



what is the main advantage of unconnected lookup..

Answer / 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

what is the main advantage of unconnected lookup..

Answer / shaik

1.to call the LKP more than once in a mapping.

Is This Answer Correct ?    9 Yes 0 No

Post New Answer

More Informatica Interview Questions

difference between informatica 8.1.1 and 8.6

0 Answers   TCS,


What do you understand by a term domain?

0 Answers  


1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.

1 Answers   CTS,


my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

10 Answers   Cap Gemini, Wipro,


Target is zero file and how can you send the email?

2 Answers   Bank Of America,






which one is better either active or passive transformation in informatica

1 Answers  


What is A cache?

2 Answers  


what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy

2 Answers   TCS,


What is resilience time?

0 Answers  


how to identify new and old values in source qualifier or any other transformations using informatica

2 Answers  


in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address

1 Answers   Cognizant,


I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

3 Answers   CSC,


Categories