Introduction of the term critical column

Question

Give a brief introduction of the term critical column?

Answer 1

A column (or usually granular) is named as critical column that altered the values over a era of time.

For illustration, there is a customer by name ‘Rick Ross’ who resided in New York for 5 years and moved to Brooklyn. Being in New York, he buys Rs. 30 Thousand Dollar worth of purchases. Now the change is the CITY in the data warehouse and the purchases now will shown in the city Brooklyn only. This type of procedure creates data warehouse incompatible. In this illustration, the CITY is the critical column. Surrogate key can be employed as a solution for this.