Interested to Buy Any Domain ? << Click Here >> for more details...
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
wf dont have integration severances how you can run?
What is a mapplet/worklet in informatica?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Differentiate between Load Manager and DTM?
What is expression transformation?
What is workflow monitor?
What is informatica powercenter repository?
What is transformation?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What do you mean by filter transformation?
How would you copy the content of one repository to another repository?
What is an aggregator transformation?
Can we use the mapping parameters or variables created in one mapping into any other reusable 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?
