Answer Posted / priyank
First of all union transformation allows duplicate ddata to
pass through. Now say we have n input groups and there are
m records coming from them. In the output group all the m
records will go through.
For a transformation to be an Active transformation, it has
to satisfy either of the below 3 conditions:
1. no of i/p <> no of o/p
OR
2. row type of the input row changes.
OR
3. Transaction scope of the input rows changes.
For union transformation as discussed above , it satisfies
the 1st and the 2nd condition. But the order in which the
input is passed through the union transformation is not
fixed as in the first record to pass through the
transformation can be from the nth source and the last
record can be from the 1st source. So here the transaction
scope of the input rows changes and hence Union
transformation is an Active transformation.
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Under what condition selecting sorted input in aggregator may fail the session?
What are the different components of powercenter?
How do you change a non-reusable transformation to reusable transformation?
What do you mean by blocking transformation?
What is target designer and target load order?
What is a grid in Informatica?
What is a joiner transformation?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Repository user profiles
Can we create a node as a gateway node and the same node can be assigned to a grid?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What's the layout of parameter file (what does a parameter file contain?)?
What is informatica?
What is dynamic cache?
What is the difference between informatica 7.0 and 8.0?