How union transformation is active ?
- 2 Answers
- 4978 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 |
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
explain about session partitions ?
What do you understand by a term domain?
Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.
my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced
how to through logic of informatica using the push down optimization into oracle.
Why touse stored procedure in ETL Application?
What's the layout of parameter file (what does a parameter file contain?)?
Describe expression transformation?
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
Define the various join types of joiner transformation?
WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...
Teradata 
