Data Warehousing Interview Questions and Answers

Data Warehousing Interview Questions and Answers
http://dba.fyicenter.com/interview/Data_Warehousing_Interview_Question...nd_Answ


What's A Data warehouse
Data Warehouse is a repository of integrated information, available
for queries and analysis. Data and information are extracted from
heterogeneous sources as they are generated....This makes it much
easier and more efficient to run queries over data that originally
came from different sources.
Typical relational databases are designed for on-line transactional
processing (OLTP) and do not meet the requirements for effective on-
line analytical processing (OLAP). As a result, data warehouses are
designed differently than traditional relational databases.



Please visit:
http://dba.fyicenter.com/interview/Data_Warehousing_Interview_Question...nd_Answ

Thank you,
Team DBAFYI - DBA Resource Center
http://dba.fyicenter.com/