What are the nine decision points of data ware housing?
Answer / mahesh
1. IDENTIFY FACT TABLE
2. IDENTIFY DIMESNION TABLE
3. DEFINE ATTRIBUTES OF ENTITIES
4. DEFINE GRANULARITY OF FACT TABLE
5. DEFINE AGGREGATES
6. SLOWLY CHANGING VARIABLES
7. PRE CALCULATED KEY FIGURES
8. HOW LONG THE DATA WILL BE KEPT
9. HOW OFTEN THE DATA IS EXTRACTED
Is This Answer Correct ? | 0 Yes | 0 No |
can anyone explain me in detail about exceptions? How to you handle them in realtime by giving one example?
What is the top transaction for extraction?
What is the ?$? as an authorization value?
What are the server related tuning?
What is the transaction for process chain?
If you are asked to change the way tables are displayed in web reporting how would you do this?
What are the steps to enable delta load for generic data sources?
How many dimensions in a cube?
what is 0unit of meassure?
What is the transaction code for generic extraction tool?
Give the variable types?
What is update routines.