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
How you know when to use a static cache and dynamic cache in lookup transformation?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Explain the types of lookup transformation?
What is the difference between informatics 7x and 8x and what is latest version?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Define mapping and session?
Why sorter is an active transformation?
What is target designer and target load order?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is a passive transformation?
what is unit testing?tell me proceedure
permutations of mapplet
What are connected or unconnected transformations?
Explain direct and indirect flat file loading (source file type) - informatica
