srinuv_11

 Profile Answers by srinuv_11 Questions by srinuv_11

• Nov 13th, 2006

 

Constraint based error will occur if the pk is duplicate  in a table

siva.v12

• Dec 20th, 2006

 

it is a primary and forigen key relationship.

Phani

• Feb 16th, 2007

 

hi,when data from a single source needs to be loaded into multiple targets, in that situation we use constraint based load ordering.Note: The target tables must have primary - foreign key relationships.regards,Phani...

dl_mstr

 Profile Answers by dl_mstr 

• Feb 10th, 2008

 

1. when data from a single source needs to be loaded into multiple targets

And multiple target has primary foreign key relation constraint based loading is used

For example :  In the first pipeline, target T_1 has a primary key, T_2 contain foreign keys referencing the T1 primary key. The PowerCenter Server loads T_1 first because it has no foreign key dependencies and contains a primary key referenced by T_2 and then it loads T2