Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

3 NF vs Star schem for data warehouse?

user-image
Question ajoutée par Muhammad Waqas Saleem , Senior Data Analyst , Volvo Cars
Date de publication: 2014/07/26
Mahmoud Younes
par Mahmoud Younes , Senior Specialist - Business Intelligence , Tamkeen Technology

You can have a Start schema in3NF, and there is no such thing as this is the best way to design a data warehouse, it all go back to the use of the DW:

- Who is going to use the DW?

- What tool is used to visualize the data: for e.g. DW -> MS OLAP -> DATA MARTS -> Client Application.

- What is the size of the data?

- What is the update frequency for the DW?

 

 

And the list goes on, so you need to be more specific to get the right answer.

More Questions Like This