Login to manage your account

Your email Please enter a valid email address.

Password Forgot Password?

Please enter a valid password.

OR

Don't have an account yet? Sign up

What is a slowly changing dimension Type 3 approach?

A Adding a column to hold the previous value alongside the current one
B Adding a new row per change
C Overwriting the value
D Deleting the record

Answer

Adding a column to hold the previous value alongside the current one

Type 3 preserves only one prior value, so it suits cases where you need current and immediately previous but not full history.

All Data Warehousing MCQs

Login to manage your account

Your email id Please enter a valid email address.

Password Forgot Password?

Please enter a valid password.

OR

Don't have an account yet? Sign up as

Jobseeker

Employer