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.
Specify the types of dimensions?
Define the efficient data structure used within the internal storage representation in RDBMS?
Explain the Aggregator Transformation?
Explain the term operational data stage (ODS) and data warehouse?
What are some of the impediments to good decision making? Given the availability of copious information, why do good managers still make bad decision?
Illustrates the introduction about economics?
What do you understand by the term deadlock in DBMS? How can it be avoided? How can it be solved once it happens?
List out the regions in which data structures are applied widely?
Describe the term Derivations, Stage Variables and Constants?
Illustrates the about Data Manipulation Language?
18,76,764
1952784 Asked
3,689
Active Tutors
1423345
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!