| |
GeekInterview.com > Interview Questions > Data Warehousing > BO Designer
| Print | |
Question: What are steps to be taken care to create a good Universe?
|
| March 03, 2007 09:04:47 |
#2 |
| Nidhii |
Database Expert Member Since: March 2007 Total Comments: 4 |
RE: What are steps to be taken care to create a good U...
|
I would like to add to that
1.Give meaningful name to the Universe
2.Give meaningful names for objects as the user may nt be aware of the technical terms of underlying objects
3.Group all similar objects(coming from single table) into same class/subclass
4. Give meaningful,similar names to alias tables
5. set cardinalities to all the joins present
6.resolve loops.
7.Resolve fan trap and chasm trap if any
8.Define contexts according to the requirement
9.Use aggregate awareness if necessary
I cud think of only these easy,but important steps.
Hope this will be useful to you
Regards,
Nidhi |
| |
Back To Question | |
