| October 10, 2007 05:00:42 |
#3 |
| Mrutyunjay |
Member Since: Visitor Total Comments: N/A |
RE: Can anybody tell me about star schema grouping |
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.
|
| |