Question

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

Answer 1

We will have to use the Union Transformation here. Union Transformation is a multiple input group transformation and it has only one output group.

1. Drag all the sources in to the mapping designer.
   
2. Add one union transformation and configure it as follows.Group Tab.
   Group Ports Tab.
   
3. Connect the sources with the three input groups of the union transformation.
   
4. Send the output to the target or via a expression transformation to the target.The entire mapping should look like this.