Note on Mege Transform: Combines two or more scehmas as a single schema, it is equivalent to UNION ALL operator in Oracle

Input datasets must have same structure(same number of columns, same names), dataypes and their datasizes

Design Steps:

• Place your source tables on the work area
• Drag the Merge transform from the object library and connect each source to merge
• Click on the merge transform, nothing to do here just validate the window, comeout from the merge transform
• Now connect it to the TGT table, give a click on validate all and save the job and execute the job