The set merge procedure type allows the merging of two or more identical tables. The tables to be merged must have exactly the same number of columns and column names.
If necessary, additional blank columns could be added to one or other of the tables to make them identical.
To use this procedure you must simply have the tables to be merged mentioned at least once in the Source Table field of a column's properties.
In this example, we will merge three load tables into a single Stage table.

  1. The browser pane shows the three Load tables:
  2. Double-click the Stage table object group and then drag one of these Load tables from the source pane on the right, into the Stage Object work area in the middle pane.
    • Name the stage table, for example stage_orders_master.
  3. Next, modify the source table column to include one instance of each of the three Load tables; the order does not matter.
    You can do this either by typing in the table directly, or by going to each of the column's Properties.
  4. Right-click the Stage table and select Create (ReCreate).
  5. Double-click the Stage table in the left pane to bring up the Properties window.
    • Click the Rebuild button to rebuild the stored procedure.
    • Select Set Merge as the procedure type.
  6. The stored procedure is rebuilt, as follows:





 

  • No labels