Question: As a consultant you are building a data warehouse for a large government agency, which has many units at different hierarchy levels. Many of the
As a consultant you are building a data warehouse for a large government agency, which has many units at different hierarchy levels. Many of the business functions are date related, such as fiscal yearmonth and calendar date. Which of the following is the best solution to handle date related information?
Create a date dimension for each business unit
Create a date dimension for each business function
Create a single date dimension containing fiscal yearmonth and calendar yearmonth mapping only
Create a single date dimension containing values for calendar and fiscal dates
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
