how lookup is acting as both active and passive ?
how is it possitble?
Answer Posted / vidyasagar
Dude Jay,
its a passive transformation
in yo case eventhough you are selecting first last or any
it will select the selected column and null for the rest of
the rows so the number of rows remains same , hence its the
passive transformation.
one more thing you can by-pass the lookup so only a passive
txn can be by-passed.
if anyone have any queries lemme know :)
Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
How do you promote a non-reusable transformation to reusable transformation?
Write the different tools in the workflow manager?
How an expression transformation differs from aggregator transformation?
How to do unit testing in informatica?
write a query to retrieve the latest records from the table sorted by version(scd)
State the limitations where we cannot use joiner in the mapping pipeline?
can u any challenge your project?
Where do we use mapping variables in informatica?
Explain the use of aggregator cache file?
What is the status code in stored procedure transformation?
Explain informatica architecture - version 8 / 9
Explain pushdown optimization $pushdownconfig parameter - informatica
How to handle decimal places while importing a flatfile into informatica?
What are the popular informatica products?
What are the types of caches in lookup? Explain them.