Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use the CREATE with an embedded SELECT statement (and tables T_DATE, CUSTOMERS_COPY, ORDERS_COPY, and T_SALESMAN) to create and load the four dimensional tables D_ORDERS, D_CUSTOMERS,
- Use the CREATE with an embedded SELECT statement (and tables T_DATE, CUSTOMERS_COPY, ORDERS_COPY, and T_SALESMAN) to create and load the four dimensional tables D_ORDERS, D_CUSTOMERS, D_TIME and D_SALESMAN as they are described in Figure 7.1.
For each Dimension, define the PK constraint and name it as follows:
PK_D_ORDERS Primary Kay for D_ORDERS
PK_D_SALEMAN Primary Kay for D_SALEMAN
PK_D_TIME Primary Kay for D_TIME
PK_D_CUSTOMERS Primary Kay for D_CUSTOMERS
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started