Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

3 NF vs Star schem for data warehouse?

user-image
Question added by Muhammad Waqas Saleem , Professional Services Consultant , Multinational Consulting firm
Date Posted: 2014/07/26
Mahmoud Younes
by Mahmoud Younes , Expert - 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

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.