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
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Explain the types of transformations?
Tell me about MD5 functions in informatica
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Clarify the utilization of aggregator cache record?
What is InformaticaPowerCenter?
What is the session task and command task?
What is event and what are the tasks related to it?
How does a rank transform differ from aggregator transform functions max and min?
What is decode in static cache?
What is olap (on-line analytical processing?
What do you mean incremental aggregation?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is the command used to run a batch?
