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

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close