INTRODUCTION
As someone responsible for administering, designing, and implementing a data warehouse, you are responsible for the overall operation of the Oracle data warehouse and maintaining its efficient performance.
A data warehouse is a relational or multidimensional database that is designed for query and analysis.Data in a data warehouse usually stores many months or years of data to support historical analysis. The data in a data warehouse is typically loaded through an extraction, transformation, and loading (ETL) process from one or more data sources such as OLTP applications, mainframe applications, or external data providers.
Datawarehousing
. Evolution of Datawarehousing - History
. The need of Datawarehousing
. Why Datawarehousing
. What is Datawarehousing - The Definition
. Datawarehousing Architecture
. Dimension table
. Fact table
. Attribute Hierarchy
. Types of Schema
. Slow Changing Dimension
. OLAP and OLTP
SHARE WITH YOUR FRIENDS