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...

What is the difference between Connected and UnConnected
Lookup Transformation.Give me one or two examples please?

Answer Posted / pradeep

1) The connected lookup t/r connected other transformations in the pipe line and it recives input data directly from pipe line.
where as unconnected lookpup t/r not connected other t/r in the pipe line and it recive input data from the result of :LKP Expression in an other t/r,that support expressions.

2)Connected lookup support user defined functions
Unconnectd doesn't support user defined functions.

3) It returns multiple output values to other t/r
Unconnected returns single output value to other t/r.

4)Connected lookup support static and dynamic cache
Unconnected supports only static cache.

5)Connected lookup cache includes output ports in the lookup condition
Where as in unconnected lookup cache include lookup ports of lookup condition.

6)Connected lookup gives multiple output ports to other t/r.
Unconnected lookup gives single output port to other t/r.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is song in infrmatica...?

2230


design of staging area?

2026


How to open an older version of an object in the workspace?

1198


What is the way to execute pl/sql script using informatica mapping?

1592


can you please explain me pre session and post session options?

7554


What is the difference between stop and abort in informatica

1086


what is informatica metadata?

1028


what is degenerated dimension?

3983


What is mapping debugger?

1006


What is expression transformation?

1089


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1629


what are factless facts? And in which scenario will you use such kinds of fact tables.

1803


What is repository manager?

984


difference between informatica 8.1.1 and 8.6

3673


What is a pre-defined event and user-defined event?

1035