Data Warehousing Interview Questions and Answers
http://dba.fyicenter.com/Interview-Questions/Data-Warehousing/
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-Questions/Data-Warehousing/
Thank you,
Team DBAFYI - DBA Resource Center
http://dba.fyicenter.com/
