Interested to Buy Any Domain ? << Click Here >> for more details...
Why the UNION TRANSFERMATION is an Active TRANSFERMATION
- 6 Answers
- 9761 Views
- Emphasis, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
In Union Transformation we may combine the data from two
(or) more sources. Assume Table-1 contains '10' rows and
Table-2 contains '20' rows. If we combine the rows of
Table-1 and Table-2 we will get a total of '30' rows in the
Target. So it is definitely an Active Transformation.
| Is This Answer Correct ? | 9 Yes | 5 No |
Answer / krishna
The above answer is correct and there is another reason to
call union transformation is active. That is UNION
trsnsformation is derived from custom transformation which
is active transformation
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / reddy
Hello Priya,
The Union Transformation is acts like as UNION ALL. The
total output is 6 records.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / narendra.s
1)A transformation that effect the no of rows or change the no of rows while processing the data.
2)In this way the union transformation is change the 10+5 records into 15 records.
3)union transformation can't remove the duplicate records.
4)we can create multiple input groups, but only one output group.
In this way we can cal union is an Active and Connected transformation.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ramz
yes u r right 6 inputs and same as 6 output right then it s active or passive
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / priya yadav
Any Tranformation that changes the no of passed records
while processing is an active transformation. Union
transformation unions the record from different
sources/transformations(whatever it is in mapping), so the
no of records input to it are different from the no of
records that you recieve as output from it. Thats why it is
considered as an active transformation.
For Example,
You union these records from tweo Sources:
Source A: Source B:
A 1 2 D 7 8
B 3 4 A 1 2
C 5 6 E 4 3
Total Input Records: 6
Output Target:
A 1 2
B 3 4
C 5 6
D 7 8
E 4 3
Total: 5
Hope it helps!!!
Thank you!!
Priya Yadav
| Is This Answer Correct ? | 1 Yes | 4 No |
Could any one to tell How to use the Oracle Analytic functions in Informatica?
How to load time dimension?
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
What is fact table? Explain the different kinds of facts.
what is index?how it can work in informatica
What is hash partition?
If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?
What are Target Options on the Servers?
What is enterprise data warehousing?
1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),
Differentiate between mapping parameter and mapping variable?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Teradata 
