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 2 slowly changing dimension do?

  1. A Inserts a new row with effective dates, preserving full history
  2. B Overwrites the existing value
  3. C Deletes the old record
  4. D Stores changes in a separate log only
Answer

Inserts a new row with effective dates, preserving full history

Type 2 is what allows a sale to be attributed to the customer's region at the time of the sale rather than their current region.

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