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 do you load alternate records into different tables through mapping flow?
tell me the rules and responsblites in our project(my project is development)
What does reusable transformation mean?
What is data caches/ index caches?
r u done any partitions in ur project?
Can you use flat files in Mapplets.
How union transformation is used?
What is dimensional table?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How do you load only null records into target? Explain through mapping flow.
What is a grid in Informatica?
What is a joiner transformation and why it is an active one?
which one is better performance wise joiner or look up
What is an expression transformation in informatica?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
