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
What is InformaticaPowerCenter?
What is meant by query override?
Differentiate between joiner and lookup transformation?
Explain scd type 3 through mapping.
Describe an informatica powercenter?
Which is the t/r that builts only single cache memory?
What can we do to improve the performance of informatica aggregator transformation?
How do you load only null records into target?
According to his methodology what all you need before you build a datawarehouse
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
What is a predefined event?
What do think which one is the better joiner or look up?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
How to generate sequence numbers without using the sequence generator transformation?
What is repository manager?