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 InformaticaPowerCenter?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How might one distinguish in the case of mapping is right or not without associating session?
How do you take back up of repository?
What is aggregator transformation in informatica?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What are the types of lookup transformation?
Explain the informatica workflow?
What is session task and command task?
What is informatica metadata and where is it stored?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
whats the logic to load the lower level of granularity of data to fact table.
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
