Sravan

• Nov 27th, 2006

 

"referential Intigrity" is all about foreign key relationship between tables. Need to check for the primary and foreign key ralationship and the existing data if any.(see if  child table has any records which are poiting to the master table records that are no more in master table.)

dl_mstr

 Profile Answers by dl_mstr 

• Feb 10th, 2008

 

You have set the session for constraint-based loading, but the PowerCenter Server is unable to determine dependencies between target tables, possibly due to errors such as circular key relationships.

Action: Ensure the validity of dependencies between target tables

pawarpossible

 Profile Answers by pawarpossible Questions by pawarpossible

• Jul 2nd, 2010

 

Check which constarint is getting violated in log and take the action accordingly.