Answer Detail: what is critical column?

GeekInterview.com > Interview Questions > Data Warehousing

Print |

Question: what is critical column?

January 01, 2007 01:34:15	#2
gssharma_msc	Database Expert Member Since: January 2007 Total Comments: 4
what is critical column?
Let us take one ex: Suppose 'XYZ' is customer in Bangalore, hez residing in the city from the last 5 years, in the period of 5yrs he has made purchases worth of 3 laks. Now, he moved to 'HYD'. When u update the 'XYZ' city to 'HYD' in ur Warehouse, all the puchases by him will show in city 'HYD' only. This makes warehouse inconsistent. So here CITY is the Critical Column.Solution is use Surrogate KeySudheer