How union transformation is active ?

Answers were Sorted based on User's Feedback



How union transformation is active ?..

Answer / kish

union t/r means multi input source merged into single output
group.and also union t/r work as union all in oracle. and it
support duplicate data but union t/r having property is
their "make it active" enable them that's why it does not
accept duplicate record.this is the process

Is This Answer Correct ?    2 Yes 1 No

How union transformation is active ?..

Answer / priyank

As per the definition of the Active transformation, the no
of rows going in should be equal to the no of rows going
out.Besides that the row id of the input rows should be the
same the row id of the out going rows.

Henceforth, union transformation is true for the first
condition where the no of rows entering is same as the no
of rows going out as Union transformation treats rows for
UNION ALL condition. But in the second condition i.e. Row
id,there is no control on the rows which enter the Union
transformation from different sources so the Row id can
change.

Is This Answer Correct ?    3 Yes 4 No

Post New Answer

More Informatica Interview Questions

Differentiate between a database and data warehouse?

0 Answers  


From where we can start or use pmcmd?

3 Answers  


How do you load only null records into target?

0 Answers  


how to read data from website into informatica? plsss send answers ASAP thanks in advance.

1 Answers   DELL,


 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?

2 Answers   DELL,






following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?

2 Answers   Patni,


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

0 Answers  


Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??

4 Answers  


what is hash table in informatica?

1 Answers   Zensar,


What is an Integration service in Informatica?

0 Answers  


scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS

1 Answers  


Tell me about MD5 functions in informatica

0 Answers  


Categories