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 are the steps involved in the migration from older version to newer version of Informatica Server?
Explain informatica architecture - version 8 / 9
What is pmcmd command?
what are 3 tech challenges/ common issues you face?
What is a stored procedure transformation?
Tell me about MD5 functions in informatica
scenario where i can use only concurrent execution of workflow.
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is the Rank index port in Rank transformation?
In informatics server which files are created during the session rums?
Can we create two repositories on same database instance in oracle?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Explain the different kinds of facts.
What is a passive transformation?
What is sequence generator transformation in informatica?