Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / priyank
As per the definition of the Active transformation, the no
of rows going in should be equal to the no of rows going
out.Besides that the row id of the input rows should be the
same the row id of the out going rows.
Henceforth, union transformation is true for the first
condition where the no of rows entering is same as the no
of rows going out as Union transformation treats rows for
UNION ALL condition. But in the second condition i.e. Row
id,there is no control on the rows which enter the Union
transformation from different sources so the Row id can
change.
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Differentiate between a repository server and a powerhouse?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How can a transformation be made reusable?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What is the difference between a connected look up and unconnected lookup?
what is $$$$?
How to handle decimal places while importing a flatfile into informatica?
What is meant by pre and post session shell command?
What is the way to execute pl/sql script using informatica mapping?
Explain incremental aggregation in informatica
How you know when to use a static cache and dynamic cache in lookup transformation?
Describe expression transformation?
In development project what is the process to follow for an etl developer from day1
Explain sql transformation in script mode examples in informatica
