What is critical column?

  • Interview Candidate
  • 12
  • 4221

Showing Answers 1 - 12 of 12 Answers

Suheer

  • Jan 29th, 2007
 

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

  Was this answer useful?  Yes

gssharma_msc

  • Jan 29th, 2007
 

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

  Was this answer useful?  Yes

Anitha

  • Feb 23rd, 2007
 

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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions