✍ Kashif M
Trends

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.


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

Comment for "Constraint based loading in Informatica"

0 comments

Post a Comment

Blog Archive