ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

3 NF vs Star schem for data warehouse?

user-image
تم إضافة السؤال من قبل Muhammad Waqas Saleem , Senior Data Analyst , Volvo Cars
تاريخ النشر: 2014/07/26
Mahmoud Younes
من قبل 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.

المزيد من الأسئلة المماثلة