Data Warehousing - what is critical column?

GeekInterview.com > Interview Questions > Data Warehousing

Go To First | Previous Question | Next Question

Data Warehousing | Question 54 of 86

what is critical column?

Total Answers and Comments: 4

Last Update: March 13, 2008 Asked by: murali

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

January 29, 2007 01:15:21

Suheer

what is critical column?

Let us take one ex: Suppose 'XYZ' is customer in Bangalore, he was 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 Key

Is this answer useful? Yes | No

January 29, 2007 01:34:15

gssharma_msc

Member Since: January 2007 Contribution: 14

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

Is this answer useful? Yes | No

February 23, 2007 13:37:22

Anitha

RE: what is critical column?

The columns(granular) that change the values over a perriod of time.

Is this answer useful? Yes | No

March 13, 2008 03:53:37

VVM.SP

Member Since: March 2008 Contribution: 7

RE: what is critical column?

It is a column, which we when update the OLTP

Is this answer useful? Yes | No

Go To Top