Data Warehousing Interview Questions and Answers

[DBA]

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/