Interested to Buy Any Domain ? << Click Here >> for more details...
Why the UNION TRANSFERMATION is an Active TRANSFERMATION
- 6 Answers
- 9736 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 |
to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?
What is the difference between OLTP and ODS?
Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project
How to delete first 3 rows & last 3 rows in target table in informatica
How do you change a non-reusable transformation to reusable transformation?
What is a mapplet/worklet in informatica?
Clarify the aggregator change?
What are the differences between oltp and olap?
Under which circumstances, informatica server creates reject files?
Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
What does role playing dimension mean?
Teradata 
