Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

connected and unconnected lookups?

Question Posted / nalini pasupulati

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

i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow

3 Answers   Wipro,

What is metadata reporter?

1 Answers   Informatica,

What are the connected or unconnected transforamations?

2 Answers  

Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?

2 Answers   Deloitte,

What is a taget load order?

2 Answers   IBM,

How to handle changing source file counts in a mapping?

3 Answers   Deloitte, TCS,

What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.

4 Answers   JPMorgan Chase,

Which is costliest transformation? costly means occupying more memory?

3 Answers  

What is the target load order?

3 Answers   HCL, Informatica,

What are the mapping parameters and mapping variables?

0 Answers   Informatica,

How might you approve all mappings in the archive all the while?

0 Answers  

Explain reference cursor?

1 Answers  

For more Informatica Interview Questions Click Here
Categories