Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

What does a Type 1 slowly changing dimension do?

  1. A Overwrites the old value, keeping no history
  2. B Adds a new row for each change
  3. C Adds a new column for the previous value
  4. D Rejects the change
Answer

Overwrites the old value, keeping no history

Type 1 is appropriate for correcting errors, where the old value was simply wrong and has no analytical meaning.

All Data Warehousing MCQs

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as