Why the UNION TRANSFERMATION is an Active TRANSFERMATION
- 6 Answers
- 8002 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 |
How might you approve all mappings in the archive all the while?
How to do unit testing in informatica?
how to convert the .doc docs into .txt format using informatica
Explain the types of transformations?
guys which is the best institute in banglore to learn informatica??
What is a surrogate key?Why we use it in a mapping?Pl give an example.
what are challenges that you faced in testing? give solution to it?
How to generate a single mapping for both the historical and incremental load.
Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?
SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?
Can we create two repositories on same database instance in oracle?
What is lookup transformation?
Teradata 
