You need to design a solution that can join a single time dimension to both fact tables

You are designing a data warehouse with two fact tables. The first table contains sales per
month and the second table contains orders per day.
Referential integrity must be enforced declaratively.
You need to design a solution that can join a single time dimension to both fact tables.
What should you do?

You are designing a data warehouse with two fact tables. The first table contains sales per
month and the second table contains orders per day.
Referential integrity must be enforced declaratively.
You need to design a solution that can join a single time dimension to both fact tables.
What should you do?

A.
Create a time mapping table.

B.
Partition the fact tables by day.

C.
Create a time dimension that can join to both fact tables at their respective granularity.

D.
Join the two fact tables.



Leave a Reply 3

Your email address will not be published. Required fields are marked *


Rami

Rami

A?
Mapping table is created for Many-Many relationship
It should be C.