| |
GeekInterview.com > Interview Questions > Data Warehousing > Business Objects
| Print | |
Question: Universe Design
Answer: How will you ensure that the universe designed is optimum? |
| March 03, 2009 01:30:51 |
#1 |
| prashantpurohit2000 |
Member Since: November 2007 Total Comments: 23 |
RE: Universe Design
|
| Some of the precautions you should always keep in mind: • Do not use automatic universe creation tool, design your universe piece by piece and insert one table at a time also the joins and cardinalities should be added step by step. • Table structure and arrangement should be as per business logic. • No tables should be such that they are not joined to any other table. • No Joins should be such that they are not included in any context and each context should have proper name aligned to business. • Use aggregate awareness, wherever possible or needed. |
| |
Back To Question | |
