Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapplets
  4. Mapping Parameters
  5. Where to Assign Parameters
  6. Mapping Outputs
  7. Generate a Mapping from an SQL Query
  8. Dynamic Mappings
  9. How to Develop and Run a Dynamic Mapping
  10. Dynamic Mapping Use Cases
  11. Mapping Administration
  12. Export to PowerCenter
  13. Import From PowerCenter
  14. Performance Tuning
  15. Pushdown Optimization
  16. Partitioned Mappings
  17. Developer Tool Naming Conventions

Developer Mapping Guide

Developer Mapping Guide

Creating Target Load Order Constraints

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.
  1. Click inside the editor.
    The mapping
    Properties
    tabs appear in the bottom window.
  2. Click the
    Load Order
    tab.
    The following image shows the
    Load Order
    tab:
    This image shows the Load Order tab with three primary and secondary constraints.
    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.
  3. To enter a constraint, click the
    New
    button.
    The Developer tool creates a row for the constraint.
  4. Click the
    Primary
    field.
    A list of the target instances in the mapping appears.
  5. Select the target instance that you want to load first.
  6. 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
  7. Enter as many constraints as you need.

0 COMMENTS

We’d like to hear from you!