What are the nine decision points of data ware housing?
Answer Posted / 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 |
Post New Answer View All Answers
What is the importance of 'start routine' in update rules?
You want to convert bex query global structure to local structure. How would you do that?
What is the use of transformation and how the mapping is done in bw?
What is an infoobject and why it is used in sap bi?
How would you measure the size of a infocube?
my intermediate is mpc and my graduation is bcom and pg is mba. learnt sap bw and abap. tell me the interview questions for the same?
What is generally included in the data target administrative task?
Can you give a list of standard web items delivered?
What are the built in javascript functions available to customize your web template?
What is the use of real-time infocube?
What are the general tuning guidelines?
What is automatic loading of similar/identical requests option?
What are the advantages of BW 3.x web server (WAS)?
why ods activation fail? What types of fails are there? What are the steps to handle
In update rules for an infocube we can specify separate update rules for characteristics of each of the key figures. In which situations is the above used?