Data Warehousing Question: Download Data Warehousing PDF

Describe Referential Integrity?

Tweet Share WhatsApp

Answer:

A rule defined on a column (or set of columns) in one table that allows the insert or update of a row only if the value for the column or set of columns (the dependent value) matches a value in a column of a related table (the referenced value). It also specifies the type of data manipulation allowed on referenced data and the action to be performed on dependent data as a result of any action on referenced data.

Download Data Warehousing PDF Read All 131 Data Warehousing Questions
Previous QuestionNext Question
What is schema?What is a Hash Cluster?