Question

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

Answer 1

We can use joiner, if we want to join the data sources. Use a joiner and use the matching column to join the tables. We can also use a Union transformation, if the tables have some common columns and we need to join the data vertically. Create one union transformation add the matching ports form the two sources, to two different input groups and send the output group to the target. The basic idea here is to use, either Joiner or Union transformation, to move the data from two sources to a single target. Based on the requirement, we may decide, which one should be used.