When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?

Answers were Sorted based on User's Feedback



When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with a..

Answer / rohan

We can use unconnected lookup multiple times in the same
mapping if required.

Is This Answer Correct ?    4 Yes 0 No

When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with a..

Answer / rascal

connected lookup is used when we need to use dynamic cache,we can return multiple o/p&need to use default values...otherwise if we want to use same lookup multiple times in the mapping then we go for un-connected lookup..In this case we can use only static cache..

Is This Answer Correct ?    0 Yes 0 No

When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with a..

Answer / poluraju

u return multiple ports you can choose connected lookup.if u want to return only one port u can choose connected or unconnected lkp.but if we want to call the same lookup multiple time with different input for single row then we choose unconnected lkp...

Is This Answer Correct ?    0 Yes 0 No

When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with a..

Answer / sandy

Connected Lookup :- When we require more than one row to be
output from the lookup.

UnConnected Lookup:- When we need only one port as output
from the lookup

Is This Answer Correct ?    1 Yes 2 No

When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with a..

Answer / rayudu

When we want to return multiple ports from a mapping we wil
use connected lookup.

An connected lookup returns only one port from the t/r. If
we want to use lookup multiple times in a mapping and if we
want to lookup data only when the condition is true we will
use unconnected lookup. (if we dont want to look up all the
records and only some records)

regards,
rayudu

Is This Answer Correct ?    2 Yes 3 No

Post New Answer

More Informatica Interview Questions

in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify

3 Answers   Patni,


If a table contains 100 records we have to fetch 50-100 records from source to target?how

7 Answers   CSC,


What the difference is between a database, a data warehouse and a data mart?

0 Answers  


How does a sorter cache works?

0 Answers  


how did u understand business requirement?

2 Answers   TCS,






comonly how meny mappings r there in Banking projects?

1 Answers  


How do you migrate data from one environment to another?

0 Answers  


Can we create out put ports in source qualifier t/r?

5 Answers   TCS,


while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?

1 Answers   IBM,


In dimension and fact table? which one holds big data?

2 Answers  


How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?

10 Answers   Wipro,


What is the difference between a shortcut of an object and copy of an object? Compare them.

3 Answers  


Categories