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
Go To First  |  Previous Question  |  Next Question 
 Reportnet  |  Question 52 of 73    Print  
Can anybody tell me about star schema grouping

  
Total Answers and Comments: 3 Last Update: October 24, 2007     Asked by: jagadish 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
March 31, 2007 11:17:55   #1  
sranand123 Member Since: March 2007   Contribution: 3    

RE: can anybody ell me about star schema groping
To isolate the conformed facts we create star schema groupings.
 
Is this answer useful? Yes | No
September 18, 2007 18:29:27   #2  
zecar Member Since: September 2006   Contribution: 52    

RE: can anybody ell me about star schema groping

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.


 
Is this answer useful? Yes | No
October 24, 2007 05:00:42   #3  
Mrutyunjay        

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.



 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape