sranand123

 Profile Answers by sranand123 

• Mar 31st, 2007

 

To isolate the conformed facts we create star schema groupings.

zecar

 Profile Answers by zecar Questions by zecar

• Sep 18th, 2007

 

The biggest advantage of star schema groupings is that they make it easier for report authors to build valid reports by avoiding double-counting and misleading associations between dimension data occurrences. In addition, performance can be faster when there are fewer tables to join. Star schema groupings also reduce the risk of users creating huge queries by mistake, and they are easier to manage, maintain, and enhance.

Mrutyunjay

• Oct 24th, 2007

 

Star Schema Groping Is a process of creating shortcut for you selected query subject,dimession masure  and relationship  for easelly understanding between relation between your regural dimession and masure dimession .and when ever you use conform dimession at that time you  make shortcut conform dimession  for each namespace .Star Schema Groping is also help full to reducing ambigous join.for that purpose we use star schema grouping.

Star schema grouping is only help full when ever you working more than one data mart(when ever you creating more then one namespace at that time star schema grouping use full)

For Single data mart no need to create star schema grouping.