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