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 / priyanka

hi
Suppose if we have 3 records with same key value, only then
first, last are considered. Based on given preference, if
it is first, it will consider the record which comes first.
If it is last, it considers the matched record which comes
by the end of that session.If there are no duplicate
records then,if there is a matched record it will return
the respective data for that record else with return NULL.
But, as it tracks all the records with some result i.e
either with its value or NULL, we consider it as passive
transformation

Is This Answer Correct ?    0 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the steps involved in the migration from older version to newer version of Informatica Server?

2153


Explain informatica architecture - version 8 / 9

1152


What is pmcmd command?

1181


what are 3 tech challenges/ common issues you face?

2395


What is a stored procedure transformation?

1113


Tell me about MD5 functions in informatica

983


scenario where i can use only concurrent execution of workflow.

3259


Can we change Dynamic to Static or Persistent cache? If so what happens?

2250


What is the Rank index port in Rank transformation?

1102


In informatics server which files are created during the session rums?

1165


Can we create two repositories on same database instance in oracle?

1143


Which means the first record should come as last record and last record should come as first record and load into the target file?

1142


Explain the different kinds of facts.

1020


What is a passive transformation?

1152


What is sequence generator transformation in informatica?

1126