Introduction to Data Warehousing

• What is Datawarehouse?
• Components of Datawarehouse
• Decision support systems
• OLTP Systems
• OLTP vs DATAWAREHOUSE
• ODS(operational data store)
• Difference between ODS and DATAWAREHOUSE
• Data Mart
• Difference between Datawarehouse and Data Mart
• Difference between Datawarehouse and ODS,OLTP
• Datawarehousing for OLTP systems
• Data cleansing
• Independent Datawarehouse
• Dependent Datawarehouse
• Meta data and Data Mining
• OLAP,ROLAP,MOLA

DATABASE DESIGN AND DATA MODELING:

• ER Model for transactional processing
• Introduction to Data Modeling
• Entities and Attributes
• What is the use of data modeling in Datawarehousing?
• Schema
• Star Schema
• Snowflake Schema
• Snowflake Schema(hybrid schema or galaxy schema)
• Fact table
• Dimension tables
• Multi dimension tables
• Grain warehousing tools consideration
• Granularity for the data warehousing