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

What are the uses of a Parameter file?

3 Answers   CSC,

wht is cdc?how to use it in creation of mappings?

6 Answers   HSBC,

SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?

1 Answers   IBM,

Is it possible to create multiple domains on a single Informatica server?

0 Answers  

How to create Target definition for flat files?

0 Answers   Informatica,

My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail

2 Answers   Amdocs,

Explain sessions and how many types of sessions are there?

0 Answers  

CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?

6 Answers  

What is galaxy shema

2 Answers   CGI,

tell me the push down optimization

2 Answers   Wipro,

If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?

2 Answers  

What are the new features of the server manager in the informatica 5.0?

1 Answers  

For more Informatica Interview Questions Click Here
Categories