GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Reportnet

 Print  |  
Question:  Can anybody tell me about star schema grouping



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.


     

 

Back To Question