Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I got the following notes from our professor regarding our star schema diagrams: 1 - it seems like the CPI dataset does not have the

I got the following notes from our professor regarding our star schema diagrams:
1- it seems like the CPI dataset does not have the location dimension, in this case you might need to add another attribute in the fact table.
2- in the wages dataset diagram, check the data and how numeric measure are reported, you might need several attributes.
I need help correcting the diagrams based on the notes provided, and also integrating the two datamarts through the shared dimensions and conducting the ETL process for the 2 datasets, are allowed to use either python or excel.
Ill attach screenshots of our diagrams, thank you very much
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Big Data In Just 7 Chapters

Authors: Prof Marcus Vinicius Pinto

1st Edition

B09NZ7ZX72, 979-8787954036

More Books

Students also viewed these Databases questions