Developer Mapping Guide

10.2.2
- 10.5.4
- 10.5
- 10.4.1
- 10.4.0
- 10.2.1

Back Next

Creating Target Load Order Constraints

Target load order constraints restrict the order that the Data Integration Service loads rows to target tables in the same mapping. Create target load order constraints on the

Load Order

tab of a mapping.

Click inside the editor.

The mapping

Properties

tabs appear in the bottom window.

Click the

Load Order

tab.

The following image shows the

Load Order

tab:

The image shows three constraints. Each constraint contains the primary target and the secondary target. The constraints specify that the Data Integration Service must load the Customer_Master target before the Customer_Orders target. The Sales_Rep_Master must load before the Customer_Orders target. The Sales_Office_Master must load before the Sales_Rep_Master.

To enter a constraint, click the

New

button.

The Developer tool creates a row for the constraint.

Click the

Primary

field.

A list of the target instances in the mapping appears.

Select the target instance that you want to load first.

In the

Secondary

field, select the target instance to load second.

You can enter the constraints in any order. You could enter the following pairs of constraints to indicate the same restrictions as in the previous image:

Primary	Secondary
Sales_Office_Master	Sales_Rep_Master
Sales_Rep_Master	Customer_Master
Customer_Master	Customer_Orders

Rename Saved Search

Table of Contents

Developer Mapping Guide

Developer Mapping Guide

Creating Target Load Order Constraints

Creating Target Load Order Constraints