Steps of data warehouse design process
State the different steps of data warehouse design process.
Expert
Steps for designing the data warehouse process are as follows:
a) Select a business process to model.
b) Select the grain of the business process
c) Select dimensions which will apply to every fact table record.
d) Select the measures which will populate every fact table record.
Illustrate the multi value or multicolumn problem? Include an example not employed in the text.
Specify the types of the tracing level?
Briefly describe the differentiation between star and snowflake schemas?
What are some of the impediments to good decision making? Given the availability of copious information, why do good managers still make bad decision?
What are the types of prompt?
What pointer type will you use while using C language to implement the heterogeneous linked list?
What is an Operational Data Store?
Describe briefly the term recursive relationship? Comprise an appropriate example?
When the collision and overlapping take place at same time, what will be the bucket size?
Give a brief introduction of the term SAS Business Intelligence?
18,76,764
1932603 Asked
3,689
Active Tutors
1432806
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!