Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
Define joiner transformation?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
How do you load first and last records into target table?
How do you load only null records into target? Explain through mapping flow.
How to generate sequence numbers using expression transformation?
What are the different options available for update strategy?
What do you mean by worklet?
What are the main issues while working with flat files as source and as targets ?
What is the different lookup cache(s)?
Explain the shared cache and re-cache?
What are the databases that informatica can connect to windows?
is it possible to index the data in cache of lkp transformation ?
Explain the different lookup methods used in informatica?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How do you handle two sessions in Informatica
