How union transformation is active ?
- 2 Answers
- 4998 Views
- Puma, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
What is the difference between normal and bulk loading? Which one is recommended?
when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/
what is threshold error in informatica?
How do you remove duplicate records in informatica? And how many ways are there to do it?
WHAT IS FACT TABLES?
Define pmcmd command?
Differentiate between source qualifier and filter transformation?
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin
what is the incremental agrrigation?
when we dont use aggregator in mapping ?
what are the types of Data warehousing ?
When the informatica server marks that a batch is failed?
Teradata 
