Home / Expert Answers / Computer Science / data-and-make-decisions-figure-1-northwind-5-and-6-oltp-schema-your-task-is-to-perform-the-follow-pa878

(Solved): data and make decisions. Figure 1. Northwind 5 and 6 OLTP Schema Your task is to perform the follow ...



student submitted image, transcription available below
data and make decisions. Figure 1. Northwind 5 and 6 OLTP Schema Your task is to perform the following tasks to design and populate a data warehouse with a DQ assurance embedded ETL process. Task 1: Design an OLAP Schema what columns, PKs, and FKs are needed. You are not required to submit your schema. It is highly recommended that you: - De-normalize Suppliers into Products table, as the suppliers are not needed in the OLAP analysis. - Have a dimension table for Categories.


We have an Answer from Expert

View Expert Answer

Expert Answer



Analyze Requirements:
Understand the business requirements and the analysis needs of the Northwind C...
We have an Answer from Expert

Buy This Answer $5

Place Order

We Provide Services Across The Globe