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
write a query to retrieve the latest records from the table sorted by version(scd)
what is the size of your data warehousing?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is a difference between complete, stop and abort?
What are the new features of informatica 9.x developer?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
tell me 5 session failure in real time how can you solve that in your project?
What are the informatica performance improvement tips
Explian the Process of deployment groups in informatica
Can we create multiple integration service on single repository?
How would you join a node to the already existing domain?
How to create Target definition for flat files?
Can u generate reports in Informatica?
What do mean by local and global repository?