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
What is the difference between informatica 7.0 and 8.0?
r u done any partitions in ur project?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What the difference is between a database, a data warehouse and a data mart?
As union transformation gives UNION ALL output, how you will get the UNION output?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Quickly characterize reusable change?
What are the guidelines to be followed while using union transformation?
Please let me know how to make Data masking in informatica..
Why do you use Mapping Parameter and mapping variable?
What is update strategy transform?
Mention few advantages of router transformation over filter transformation.
What is the way to execute pl/sql script using informatica mapping?
Explain what are the different versions of informatica?