Table of Contents


  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. Datatype Reference
  17. Configure the Web Browser

Setting the Target Load Order

Setting the Target Load Order

You can configure the target load order for a mapping containing any type of target definition. In the Designer, you can set the order in which the Integration Service sends rows to targets in different target load order groups in a mapping. A target load order group is the collection of source qualifiers, transformations, and targets linked together in a mapping. You can set the target load order if you want to maintain referential integrity when inserting, deleting, or updating tables that have the primary key and foreign key constraints.
The Integration Service reads sources in a target load order group concurrently, and it processes target load order groups sequentially regardless of the type of target. If the target is a copy of the same flat file target and you specify the Append if Exists property for the target in the session properties, the Integration Service processes all the target load order groups.
To specify the order in which the Integration Service sends data to targets, create one source qualifier for each target within a mapping. To set the target load order, you then determine in which order the Integration Service reads each source in the mapping.
The following figure shows two target load order groups in one mapping:
Target Load Order Group A includes a source, Source Qualifier transformation, and a target. Target Load Order Group B includes two sources and Source Qualifier transformations, which connect to a Custom transformation, which connects to a target.
In this mapping, the first target load order group includes ITEMS, SQ_ITEMS, and T_ITEMS. The second target load order group includes all other objects in the mapping, including the TOTAL_ORDERS target. The Integration Service processes the first target load order group, and then the second target load order group.
When it processes the second target load order group, it reads data from both sources at the same time.
  1. Create a mapping that contains multiple target load order groups.
  2. Click Mappings > Target Load Plan.
    The Target Load Plan dialog box lists all Source Qualifier transformations in the mapping and the targets that receive data from each source qualifier.
  3. Select a source qualifier from the list.
  4. Click the Up and Down buttons to move the source qualifier within the load order.
  5. Repeat steps 3 to 4 for other source qualifiers you want to reorder.
  6. Click OK.

Updated July 02, 2020