Home / Expert Answers / Other / For part 1, you have made a significant improvement. Here are some things that you can further work

For part 1, you have made a significant improvement. Here are some things that you can further work ...

For part 1, you have made a significant improvement. Here are some things that you can further work on. Your fact table should include only attributes with FK and facts. In the fact the PK is the combination of attributes with FKs. No synthetic key is needed. Date should be a dimension as a table. The keys in the dimension tables should be of type serial, did you do that? The etl seems simple and I am not sure you handle duplications in dimension tables. In my example, I have used the reference row filter. Give some stats about date in/out of etl.

Radio Active Tutors is a freelance academic writing assistance company. We provide our assistance to the numerous clients looking for a professional writing service.

NEED A CUSTOMIZE PAPER ON THE ABOVE DETAILS?
Order Now

OR

Get outline(Guide) for this assignment at only $10

Get Outline $10

**Outline takes 30 min - 2 hrs depending on the complexity and size of the task

Place a Quick Order

Our verified writers got you covered. Let us help you balance between studies, work, and family.

We provide our assistance to the numerous clients looking for a professional writing service.

Order Now

OR

Get outline for this assignment at only $10

Get Outline $10