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

Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?

2 Answers   GE,


What is a poling?

2 Answers  


what is informatica metadata?

0 Answers  


Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin

1 Answers  


I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?

5 Answers   Syntel,






what are the deliverables?in your project?

0 Answers   DELL,


what is mapping parameter?

2 Answers   Cap Gemini,


pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

0 Answers   HCL,


Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.

2 Answers  


can we override a native sql query within informatica? How do we do it?

0 Answers  


What happens when a session fails and you click on recover?

0 Answers  


Diffrence between 7.1,8.1 and 8.6

3 Answers   HCL, Wipro,


Categories