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

When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?

Answer Posted / rayudu

When we want to return multiple ports from a mapping we wil
use connected lookup.

An connected lookup returns only one port from the t/r. If
we want to use lookup multiple times in a mapping and if we
want to lookup data only when the condition is true we will
use unconnected lookup. (if we dont want to look up all the
records and only some records)

regards,
rayudu

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

explan ur project architecture?

2126


What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1120


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

1147


How to start a workflow using pmcmd command?

1303


Write the different tools in the workflow manager?

1112


How to create the source and target database connections in server manager?

1129


In warehouses how many schemas are there?

1128


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1129


Separate from an archive server and a powerhouse?

1006


What are the issues you have faced in your project? How did you overcome those issues?

2411


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

3921


What is a connected transformation?

1182


What are the advantages of using informatica as an etl tool over teradata?

1073


Have you worked with/created Parameter file

1710


What is union transformation in informatica?

1189