The Merge Data template joins two data sources based on a user specified join condition. The template also compares attributes for null values while performing the merge.
The Merge Data Template merges two data sources with similar fields to produce a single set of data that has the non-empty fields from both sources. For example, if you have two tables with attributes such as email, address, and phone number, then the Merge Data Template will allow you to merge the two tables so that if any of the attributes in one table is empty, it will pick up the values for these attributes from the other table. This template is very handy in the following situations:
Template Mapping in Informatica Cloud Template Designer :
Click to view larger image