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

What is the function of look up transformation?

1132


In which transformation you cannot drag ports into it?

1330


Explain lookup transformation source types in informatica

1108


Why sorter is an active transformation?

1206


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

1622


What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1182


Differences between connected and unconnected lookup?

1227


How can you generate reports in informatica?

1041


What is dimensional table?

1076


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2289


Partition, what happens if the specified key range is shorter and longer

2509


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

1275


what is the size ur source like(file system or database)? how many record daily come u r banking project?

2155


is it possible to index the data in cache of lkp transformation ?

2036


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

2378