What are the steps to build the datawarehouse ?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What are the steps to build the datawarehouse ?

Gathering bussiness requiremnts
Identifying Sources
Identifying Facts
Defining Dimensions
Define Attribues
Redefine Dimensions & Attributes
Organise Attribute Hierarchy & Define Relationship
Assign Unique Identifiers
Additional convetions:Cardinality/Adding ratios

(Continued on next question...)

Other Job Interview Questions

• How do you load the time dimension?
• Why should you put your data warehouse on a different system than your OLTP system?
• What is the difference between view and materialized view?
• What is the main differnce between schema in RDBMS and schemas in DataWarehouse....?
• How are the Dimension tables designed?
• What is the difference between view and materialized view?
• Why is Data Modeling Important?
• What is fact less fact table? where you have used it in your project?
• What is the difference between ODS and OLTP?
• What's the data types present in bo?n what happens if we implement view in the designer n report
• More...