Can I connect tables from multiple Pipelines to a common Destination table?

Yes, you can select the same Destination table in multiple Pipelines. The Destination table contains all the columns of the Source tables. If any Source table column does not exist already in the Destination table, it gets created.

To connect the Source table to the desired Destination table, in the Schema Mapper:

  1. Disable Auto Mapping for the Object from the Mapping Summary Page.

  2. Click Change Destination Table and select the Destination table from the drop-down menu.

  3. Click APPLY CHANGES.

  4. Repeat the above steps for all the tables in the other Pipelines.

Once the tables are connected, the data from the tables load into the selected Destination table as per the primary key defined in the table and the schedule of the respective Pipelines.

Read more about Changing the Destination table.


Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Nov-07-2022 NA Created as a new document.
Last updated on 03 Nov 2022

Tell us what went wrong