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

Why is the date dimension almost always included in a dimensional model?

A It supplies calendar attributes such as fiscal period and holiday flags that dates alone cannot
B It reduces storage
C It enforces referential integrity
D It speeds up joins only

Answer

It supplies calendar attributes such as fiscal period and holiday flags that dates alone cannot

Fiscal calendars, week numbering and business day flags cannot be derived reliably from a raw date at query time.

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