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
Define Pmrep command?
How to do the error handling of if ur source is flatfiles?
waht type of interface is used for testing the data in informatica
server hot-ws270 is connect to Repository B. What does it mean?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is the different lookup cache(s)?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Write the prerequisite tasks to achieve the session partition?
What is informatica metadata and where is it stored?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What are the measure objects?
How to differentiate between the active and passive transformations?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What are the new features of Power Center 5.0?
Explain the scenario which compels informatica server to reject files?
