The MSSQLServerDataMergerParentChild project contains one process
mssqldatamergerparentchild.ParentChildData process. This project demonstrates how the plug-in handles inserting of data in the parent table and the child table.
ParentChildData Process
In this example, the Data Merger activity inserts data in the parent table and the child table. The following figure shows the
ParentChildData process:
JDBC Connection Resource
In this example, the JDBC Connection resource is configured as follows:
ADB Configuration Resource
In this example, the ADB Configuration resource is configured as follows:
The table schema is defined by using the Schemas tab. The different tabs on the right are shown below.
The Configuration tab:
The Schema tab:
The Options tab:
The Child Exception Table Mapping tab:
Copyright © 2022. TIBCO Software Inc. All Rights Reserved.
