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

How do you implement configuration management in Informatica?

1 Answers  


How the dimensions will be loaded?

0 Answers   HCL,


If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?

4 Answers  


I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

2 Answers   CTS,


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

0 Answers  






What are the basic needs to join two sources in a source qualifier?

3 Answers  


performance tuning of Informatica

1 Answers  


Describe the impact of several join conditions and join order in a joiner transformation?

0 Answers  


Differentiate between a repository server and a powerhouse?

0 Answers  


what is the gap analysis?

1 Answers  


how the informatica server sorts the strings values in rank transformations?

3 Answers   TCS,


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

0 Answers   Saama Tech,


Categories