Constraint Based Loading in Informatica

Hello all,

Let us explore what is is constraint based loading and what is the use of it in Informatica.

Constraint Based Loading is basically a session level property, when we load the table in to multiple target s from a source, it should load the parent table first and child table next.  We cannot load the child table and then load the parent table.

Constraint based loading will work under the following condition:

* Target table must have parent-child relationship
*In the properties general tab in Session, select "Treat rows as Insert".( Updates cannot be used with constraint based loading while insert)

* one source to multiple targets(must have key relationships), we must use constraint base loading.

To achieve constraint based loading , In Joiner transformation>> Session Properties>> config>> enable the Constraint based loading option ( check the pic below)

Kindly share if you have any suggestions .