Q
Manage Learn to apply best practices and optimize your operations.

Clarification: Problem when re-enabling referential integrity

In your response to the question regarding referential constraints on a data warehouse, you stated: "At times, we disable this during loading cycles, but they are always restored after a load is complete. However, if these constraints are not re-enabled to fail to re-enable, this is a clear indication that your load routines did not perform as expected."

I don't understand the phrase "...are not re-enabled to fail to re-enable...".

Can you provide an explanation of this phrase?

This was last published in December 2003

Dig Deeper on Oracle data warehousing

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close