Interested to Buy Any Domain ? << Click Here >> for more details...
How union transformation is active ?
- 2 Answers
- 5780 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 |
I still need further explanation about the difference between active and passive transformation with some examples.Thank You
How to display null values on a target & non-null values on a target?
how to through logic of informatica using the push down optimization into oracle.
HOW TO GET THE LATEST DATA IN SCD ?
How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?
As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
What are mapping parametres and variables in informatica?
Define Pmrep command?
How to generate the HTML output using Informatica.
What is difference between a gateway node and worker node?
In which circumstances that informatica server creates Reject files?
Teradata 
