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
What is union transformation in informatica?
What are the different lookup cache(s)?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Enlist the differences between database and data warehouse.
How big was your fact table
tell me about your project functionality
What are the types of schemas we have in data warehouse and what are the difference between them?
What do you mean by blocking transformation?
What are the tasks that source qualifier perform?
What is the difference between a repository server and a powerhouse?
What is meant by LDAP users?
What are the various types of transformation?
permutations of mapplet
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
How to elaborate tracing level?
