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.
Write down the unsupported repository objects for mapplet?
Briefly describe the foreign key columns in dimension table and fact table?
Is it possible that two tasks be assigned to the similar Partition in Sybase?
Define the Fully Functional dependency.
Illustrates the term explain and how does this work?
Explain the stored procedure in the Teradata?
Write down the brief notes on multidimensional data model.
Explain what do you mean by the virtual warehouse?
Explain why it is still essential to have at least certain familiarity with file processing systems even although it has become apparent that traditional file processing systems contain a number of shortcomings and restrictions.
Explain how teradata ensures that there are no duplicate rows being inserted when it’s a SET table?
18,76,764
Questions Asked
21,311
Experts
9,67,568
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!