How union transformation is active ?
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 |
explain abt union t/r?
How might one distinguish in the case of mapping is right or not without associating session?
What are the types of lookup transformation?
in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address
My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?
wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35
What does update strategy mean, and what are the different option of it?
What is the main difference between a Joiner Transformation and Union Transformation?
What are the types of groups in Router transformation?
How can we improve session performance in aggregator transformation?
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
How are indexes created after completing the load process?