How Union Transformation is an Active Trans?
- 6 Answers
- 18322 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / hardeep
The Union transformation is a multiple input group transformation that you can use to merge data from multiple pipelines or pipeline branches into one pipeline branch. Using the Union transformation to merge data from multiple sources is similar to using the UNION ALL SQL statement to combine the results from two or more SQL statements. Similar to the UNION ALL statement, the Union transformation does not remove duplicate rows.
You can connect heterogeneous sources to a Union transformation. The Union transformation merges sources with matching ports and outputs the data from one output group with the same ports as the input groups.
| Is This Answer Correct ? | 5 Yes | 3 No |
Answer / ravi
hi all please post relevant answers the question is why
union transformation is active transformation
not the properties of union transformation
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / krishraj
It is simple logic, UNION fectches the commmon records
between two tables and it emliminated un-common records. So
it will be Active transformation which means it will change
the number of records.
Any other answers please....
| Is This Answer Correct ? | 1 Yes | 38 No |
The simple ligic of Union is that, It capture all the
unique recorde from bothe the source.
suppose if you have 10 records in table A and 10 records in
table B, in which 3 records are same in both the tables.
Then after using the Union transformation you will get 17
records, as the rescords which are getting duplicated will
not be in the output.
| Is This Answer Correct ? | 5 Yes | 47 No |
What is a configuration management?
What if the source is a flat-file?
What is batch and describe about types of batches?
how can we run workflow with pmcmd?
Define pmcmd command?
performance wise which one is better in joiner and lookup transformation
What are the uses of a Parameter file?
if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?
9 Answers BirlaSoft, Genpact, L&T, Syntel,
In any project how many mappings they will use(minimum)?
What are the methods for creating reusable transforamtions?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Teradata 
