Why the UNION TRANSFERMATION is an Active TRANSFERMATION
- 6 Answers
- 7953 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 can the following be achieved in 1 single Informatica Mapping. * If the Header table record has error value(NULL) then those records and the corresponding child records in the SUBHEAD and DETAIL tables should also not be loaded into the target(TARGET1,TARGET 2 or TARGET3). * If the HEADER table record is valid, but the SUBHEAD or DETAIL table record has an error value (NULL) then the no data should be loaded into the target TARGET1,TARGET 2 or TARGET3. * If the HEADER table record is valid and the SUBHEAD or DETAIL table record also has valid records only then the data should be loaded into the target TARGET1,TARGET 2 and TARGET3. =================================================== HEADER COL1 COL2 COL3 COL5 COL6 1 ABC NULL NULL CITY1 2 XYZ 456 TUBE CITY2 3 GTD 564 PIN CITY3 SUBHEAD COL1 COL2 COL3 COL5 COL6 1 1001 VAL3 748 543 1 1002 VAL4 33 22 1 1003 VAL6 23 11 2 2001 AAP1 334 443 2 2002 AAP2 44 22 3 3001 RAD2 NULL 33 3 3002 RAD3 NULL 234 3 3003 RAD4 83 31 DETAIL COL1 COL2 COL3 COL5 COL6 1 D001 TXX2 748 543 1 D002 TXX3 33 22 1 D003 TXX4 23 11 2 D001 PXX2 56 224 2 D002 PXX3 666 332 ======================================================== TARGET1 2 XYZ 456 TUBE CITY2 TARGET2 2 2001 AAP1 334 443 2 2002 AAP2 44 22 TARGET3 2 D001 PXX2 56 224 2 D002 PXX3 666 332
My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.
What is hash partition?
wht is full process of Information source to target just like stg to productuon and development
Can a joiner be used in a mapplet.
How to generate sequence numbers without using the sequence generator transformation?
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
What is the difference between a router and a filter transformation?
1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.
5 Answers FCS, IBM, Satyam, TCS,
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What are the components of workflow manager?
my session have to run Monday to Saturday not run sunday how to sedule in informatica level?
1 Answers Infinite Computer Solutions,
Teradata 
