connected and unconnected lookups?

Answers were Sorted based on User's Feedback



connected and unconnected lookups?..

Answer / hariom sharma

Connect lookup returns multiple columns for same whereas
UnConnect Lookup has only one out put port for each rows

Is This Answer Correct ?    3 Yes 0 No

connected and unconnected lookups?..

Answer / sai suresh

Connected lookup is participats in Mapping level and it
will takes multipul inputs and provides multipul outputs.\
Unconnected lookup is does't participats in Mapping level
and it will takes multipul inputs and provied single output
only

Is This Answer Correct ?    2 Yes 0 No

connected and unconnected lookups?..

Answer / rekha

CONNECT LOOKUP IT INVOVES IN A MAPPING PIPELINE. IT
RECEIVES MULTIPLE INPUTS AND PROVIDES NULTIPLE OUTPUT.
SUPPORTS USER DEFINED VALUES
DYNAMIC CACHE
UNCONNECTED: IT DOES NOT INVOLVE IN A MAPPING PIPELINE. IT
IS CONNECTED FROM THE RESULT OF :LKP() EXPRESSION IN
ANOTHER TRANSFORMATION
IT RECEIVES MULTIPLE INPUTS AND PROVIDE A SINGLE OUTPUT
THAT IS RETURN PORT
IT DOES NOT SUPPORT USER DEFINED VALUES
STATIC CACHE

Is This Answer Correct ?    0 Yes 0 No

connected and unconnected lookups?..

Answer / viresh

Unconnected lookup can use multiple time in expression for
fetching different values from lookup table.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

Why update strategy and union transformations are active?

0 Answers  


What are junk dimensions?

0 Answers  


Why we use ENABLE HIGH PRECISION in session properties?

2 Answers   Cognizant,


How to do the error handling of if ur source is flatfiles?

0 Answers  


explain one complex mapping with logic? sales project?

0 Answers   Accenture, JPMorgan Chase,






what is mapping override?

2 Answers   Cap Gemini,


hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.

10 Answers  


there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

1 Answers   Emphasis,


Why should we use star schema in datawarehouse design?

2 Answers   Wipro,


Explian the Process of deployment groups in informatica

0 Answers   Informatica,


What is parameter file?

2 Answers  


how to move the mappings from your local machine to claint place?

2 Answers  


Categories