Interested to Buy Any Domain ? << Click Here >> for more details...
Why the UNION TRANSFERMATION is an Active TRANSFERMATION
- 6 Answers
- 9531 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 to join the 2 different table with different columns in informatica?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
How to fix the etl bugs..Tell me the process?
Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V
Name the different lookup cache(s)?
select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
what is upstream and downstream transformation?
where actually the usage of push down optimization happens...
why u go for dimensions ?
Explain lookup transformation source types in informatica
If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?
Teradata 
