What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

-- Download Merge Transform as PDF --


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

merge1

merge2

What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

Leave a Reply

Your email address will not be published. Required fields are marked *


*