Workflow Basics Guide

10.4.0
- 10.5

Back Next

Constraint-Based Loading

In the Workflow Manager, you can specify constraint-based loading for a session. When you select this option, the Integration Service orders the target load on a row-by-row basis. For every row generated by an active source, the Integration Service loads the corresponding transformed row first to the primary key table, then to any foreign key tables. Constraint-based loading depends on the following requirements:

Active source.
Related target tables must have the same active source.

Key relationships.
Target tables must have key relationships.

Target connection groups.
Targets must be in one target connection group.

Treat rows as insert.
Use this option when you insert into the target. You cannot use updates with constraint-based loading.

Working with Relational Targets

Active Source

Key Relationships

Target Connection Groups

Treat Rows as Insert

Example

Enabling Constraint-Based Loading

Download Guide