You are designing a customer dimension for a multidimensional OLAP (MOLAP) database. The dimension table will contain millions of rows of data.
Customer dimension attributes will come from the following two sources:
- An enterprise resource planning (ERP) system that contains millions of rows of data. Attributes from this source will be updated daily.
- A marketing database that contains thousands of rows of data representing customers’ geographic information. Attributes from this source will be updated monthly.
Most report queries against the cube use attributes from both sources. Customers in the cube dimension will frequently be filtered by the geographic attributes.
You need to design the dimension table and cube dimension to ensure that report queries perform well, and minimize the time required to reprocess cube attributes.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Create a dimension table for each source. Create one cube dimension that joins the two dimension tables together.
B. Create one dimension table that combines data from both sources. Create a cube dimension for each source.
C. Create one dimension table that combines data from both sources. Create one cube dimension that references the dimension table.
D. Create a dimension table for each source, and a cube dimension for each source.
