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

A session S_MAP1 is in Repository A. While running the session error message has displayed

1 Answers  

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers  

What are the differences between source qualifier and joiner transformation?

0 Answers  

how can we use sorter transformation in joins?

5 Answers   IBM,

1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override

3 Answers   IBM,

What is union transformation?

0 Answers  

How/where can i install Informatica software with oracle or teradata as database

0 Answers  

Differences between connected and unconnected lookup?

0 Answers  

Where is the cache stored in informatica?

5 Answers   Infosys, Satyam,

If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?

2 Answers   IBM, WalMart,

What do you mean incremental aggregation?

0 Answers  

tell me the push down optimization

2 Answers   Wipro,

For more Informatica Interview Questions Click Here
Categories