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 |
Differentiate between a database and data warehouse?
From where we can start or use pmcmd?
How do you load only null records into target?
how to read data from website into informatica? plsss send answers ASAP thanks in advance.
 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?
following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??
what is hash table in informatica?
What is an Integration service in Informatica?
scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS
Tell me about MD5 functions in informatica