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

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

متابعة

Is there any condition we store degenerate dimension in separate table?

user-image
تم إضافة السؤال من قبل Mohsin Zubair , Team Lead Of Data warehouse Team , Zong Telecom
تاريخ النشر: 2016/03/16
bilal mustafa
من قبل bilal mustafa , BigData Consultant , LigaData

When the cardinality of column value is high, instead of maintaining a separate dimension and having the overhead of making a join with fact table, degenerated dimensions can be build, Example:  a purchase order number.  These columns store something that we want to have (the purchase order number), but to create an empty dimension table would only slow things down.  So, to ensure we don't feel bad about breaking the "only a measure or a dimension in the fact table" rule, we just CALL them dimensions- even without the table

Mthulisi Moyo
من قبل Mthulisi Moyo , Data Mining Specialist , Econet Wireless Zimbabwe

A degenerate dimension is not normally stored in its own separate table since most of the interesting attributes about it would be stored in another table for analytics

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

هل تحتاج لمساعدة في كتابة سيرة ذاتية تحتوي على الكلمات الدلالية التي يبحث عنها أصحاب العمل؟