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  >  BO Designer

 Print  |  
Question:  What are steps to be taken care to create a good Universe?



April 04, 2007 03:36:25 #3
 Kumar Ranu   Member Since: Visitor    Total Comments: N/A 

RE: What are steps to be taken care to create a good U...
 
I would like to add...

Universe contains Dimensions and facts.
These are linked with joins so there must be indexes on the dimensions table's columns and if nessesary fact table's columns.

Mostly Bitmap indexes are recomended as for repeated values for unique ones one can use binary indexes.

second one..

Prompts try to find out what kind of prompts are required like is it query based or object based.

Should hide the classes from the users which contains useless objects.

Ranu
     

 

Back To Question