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

Explain the different kinds of facts.

981


Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2034


What is incremental aggregation?

1081


Write the unconnected lookup syntax and how to return more than one column.

1110


What is intricate mapping?

1202


What do you mean by enterprise data warehousing?

1063


Enlist the various types of transformations.

1053


What is a sorter transformation?

1102


Explain what are the different types of transformation available in informatica.

1143


How to generate sequence numbers using expression transformation?

1087


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9817


How many ways a relational source definition can be updated and what are they?

1014


explain abt ur project architecture?

2192


What are session parameters ? How do you set them?

1848


How can we use mapping variables in informatica?

1061