Answer Posted / krishraj
It is simple logic, UNION fectches the commmon records
between two tables and it emliminated un-common records. So
it will be Active transformation which means it will change
the number of records.
Any other answers please....
| Is This Answer Correct ? | 1 Yes | 38 No |
Post New Answer View All Answers
What is the scenario which compels informatica server to reject files?
What is an expression transformation?
How to generate sequence numbers without using the sequence generator transformation?
What are the new features of Power Center 5.0?
What will be the approach?
Why update strategy and union transformations are active? Explain with examples.
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What are the modules in Power Center
What is meant by active and passive transformation?
What is enterprise data warehousing?
How you prepared reports for OLAP?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How to use procedural logic inside infromatica?
What is confirmed fact in dataware housing?