Why the UNION TRANSFERMATION is an Active TRANSFERMATION
Answer Posted / chanakya
In Union Transformation we may combine the data from two
(or) more sources. Assume Table-1 contains '10' rows and
Table-2 contains '20' rows. If we combine the rows of
Table-1 and Table-2 we will get a total of '30' rows in the
Target. So it is definitely an Active Transformation.
| Is This Answer Correct ? | 9 Yes | 5 No |
Post New Answer View All Answers
What is Data Caches size?
What are the features of complex mapping?
How big was your fact table
Can we create a node as a gateway node and the same node can be assigned to a grid?
Explain the pipeline partition with real time example?
What is a pre-defined event and user-defined event?
What are the different types of transformation available in informatica.
Suppose we do not group by on any ports of the aggregator what will be the output?
When do you use sql override in a lookup transformation?
How to load the data from people soft hrm to people soft erm using informatica?
Can we change Dynamic to Static or Persistent cache? If so what happens?
In informatica workflow manager, how many repositories can be created?
What is main use of mapplet?
lookup transformation with screenshots
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?