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
Explain pmcmd command usage in informatica
Why do we need informatica?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is a pre-defined event and user-defined event?
What do mean by local and global repository?
What is a repository manager?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How is union transformation utilized?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
what are the deliverables?in your project?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
hi real timers . iam waiting for ur reply regarding ETL TESTING
How we can create indexes after completing the loan process?
How to update source definition?
Write the unconnected lookup syntax and how to return more than one column.