Interested to Buy Any Domain ? << Click Here >> for more details...
how lookup is acting as both active and passive ?
how is it possitble?
- 9 Answers
- 60836 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / eswar
Both Lookup transformations are passive
"A passive transformation does not change the number of
rows that pass through it, such as an Expression
transformation that performs a calculation on data and
passes all rows through the transformation."
And
"An active transformation can change the number of rows
that pass through it, such as a Filter transformation that
removes rows that do not meet the filter condition."
Therefore, the Lookup transformations work as passive but
not as active transformations.
| Is This Answer Correct ? | 7 Yes | 26 No |
Post New Answer View All Answers
What is an expression transformation?
in reporting we add some new objects,how we get the count of the newly added objects to the report
How can we use mapping variables in informatica?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
tell me the rules and responsblites in our project(my project is development)
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is the Rank index port in Rank transformation?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Explain joiner transformation in informatica
Briefly define a session task?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Define Pmrep command?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Plz can any one say me how to get the informatica certification materials and dumps
what is the complex transformation you used in informatica
