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 diff between connected and unconnected lookup?

Answer Posted / padmavathi

Connected Lookup:
Part of the mapping dataflow.
Returns multiple values by linking output ports to
another transformation
Executed for every record passing through the transformation
More Visible, shows where the lookup values are used.

Unconnected Lookup:
Seperate from the mapping dataflow.
Returns one value by checking the return port option for
the output that provides the return value
only executed when the lookup function is called
Less visible, as the look is called from an expression
within another transformation
Default values are ignored

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1787


Reusable transformation and shortcut differences

1838


Explain sessions and how many types of sessions are there?

1002


Is stop and abort are same in informatica?

995


Explain the types of lookup transformation?

1041


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1899


How many number of sessions can one group in batches?

1157


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3861


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1998


what is unit testing?tell me proceedure

2219


How to create or import flat file definition in to the warehouse designer?

1067


Is it possible to use a client with different version than that of its Informatica server?

1134


What is substr in informatica?

1201


How do you load unique records into one target table and duplicate records into a different target table?

1237


Implementation methodology

1706