✍ Kashif M ™
☎ +91 9994883085
✉ kashif7222@gmail.com


Sunday, 16 February 2014

Constraint based loading in Informatica

By on February 16, 2014

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.

mkashu: Constraint based loading in Informatica
Review : Kashif | Kashif
Update: February 16, 2014 | Rating: 4.5

Comment for "Constraint based loading in Informatica"


Post a Comment

Blog Archive