2 - Data warehouse Architecture Overview

A quick video to understand standard Datawarehouse architecture. It consists of following layers

1. Data Source layer
2. ETL
3. Staging Area
4. Datawarehouse - Metadata, Summary and Raw Data
5. OLAP, Reporting and Data Mining

Data warehouse is populated from multiple sources for an organisation. All these source system comes under Data Source layer. Some of the source systems are listed below:

1. Operations Systems -- such as Sales, HR, Inventory relational database.
2. ERP (SAP) and CRM (SalesForce.com) Systems.
3. Web server logs and Internal market research data.
4. Third-party data - such as census data, demographics data, or survey data.

ETL Tools: Talend Open Studio, Jaspersoft ETL, Ab initio, Informatica, Datastage, Clover ETL, Pentaho ETL, Kettle

For more details visit http://www.vikramtakkar.com/2015/09/d...

Datawarehouse Playlist:
Learn Data warehouse & Data warehousing

• #education
• #data_warehouse
• #data_warehouse_architectures
• #datawarehouse_architecture
• #etl
• #olap
• #metadata
• #data_mining
• #staging_area
• #datawarehousing_tutorial
• #learn_datawarehousing
• #datawarehousing_concepts
• #data_warehouse_basics
• #why_data_warehousing
• #talend_open_studio
• #jaspersoft_etl
• #data_warehouse_modelling
• #what_is_data_warehouse
• #business_intelligence