Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / hardeep
The Union transformation is a multiple input group transformation that you can use to merge data from multiple pipelines or pipeline branches into one pipeline branch. Using the Union transformation to merge data from multiple sources is similar to using the UNION ALL SQL statement to combine the results from two or more SQL statements. Similar to the UNION ALL statement, the Union transformation does not remove duplicate rows.
You can connect heterogeneous sources to a Union transformation. The Union transformation merges sources with matching ports and outputs the data from one output group with the same ports as the input groups.
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
How many transformations can be used in mapplets.
Explain the mapping variable usage example in informatica
Explain scd type 3 through mapping.
Explain the aggregator transformation?
As union transformation gives UNION ALL output, how you will get the UNION output?
Clarify the utilization of aggregator cache record?
difference between informatica 8.1.1 and 8.6
How can we use mapping variables in informatica? Where do we use them?
Why do we need informatica?
What are 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 you prepared reports for OLAP?
how tokens will generate?
What are the different types of transformation available in informatica.
Have you worked with/created Parameter file
Mention few power centre client applications with their basic purpose?
