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
Describe expression transformation?
Make a note of the quantity vaults made in informatica?
How to do unit testing in informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How to generate sequence numbers?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
How to load last n records of file into target table - informatica
What are the types of caches in lookup? Explain them.
Write the prerequisite tasks to achieve the session partition?
Differentiate between a database and data warehouse?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
How we can create indexes after completing the loan process?
What are roles and groups and benefits of using them?
what are the deliverables?in your project?
What is rank transformation?
