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

how lookup is acting as both active and passive ?
how is it possitble?

Answer Posted / meenal

In Informatica 9.1 Lookup is active because of property - "Lookup policy on multiple match", this can be chosen as first, last, any value or all values. So now we can configure the Lookup transformation to return all rows that match a lookup condition. Hence, a Lookup transformation is an active transformation when it can return more than one row for any given input row.

However this property is available only for connected lookup, unconnected lookups are still passive.

Is This Answer Correct ?    43 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Please let me know how to make encryption and decryption with example?

1947


draw informatica architecture 8.6 ?

3930


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2249


Define joiner transformation?

1102


can anyone explain me about retail domain project in informatica?

7999


Can you generate sequence numbers without using the sequence generator transformation?

1162


How identifying bottlenecks in various components of informatica and resolving them?

1178


What is rank transform?

1061


How to use pmcmd utility command?

1077


How to join three sources using joiner? Explain though mapping flow.

1190


What is informatica worklet?

1115


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

3924


what is index?how it can work in informatica

2083


Enlist the differences between database and data warehouse.

1164


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

1264