INTRODUCTION
Transaction Database
Transaction Database Definition and features
E-R Data Model
Database Normalization using Six Normal Forms
Database Denormalization

Warehouse Database
Data Warehouse Definition and Features
Difference between Transaction Database and Warehouse Database
Dimensional Data Model
Star Schema Model
Star Flake Schema Model
Snow Flake Schema Model
Extended Star Schema Model
Galaxy Schema Model
Cube Designing using different models
Denormalization of  Data Warehouse
Other Databases
Data Mart
Staging Database
Operation Data Storage/Source (ODS)

Database Modeling using ERWIN
Logical Data Model and Physical Data Model
Models, Subject Areas and Display Objects
Entities, Relations, Attributes and Business Rules
Relation Cardinalities, Verb Phrases, Relation Types & Referential Integrity
ERWin Macros, Model Properties, Model Mart

ETL PROCESS

INFORMATICA
Introduction to ETL Process
Informatica Packages
Components of Informatica Tool
Informatica Repository Server/Service:
Setting up Informatica Service using Repository Server Setup Tool
Starting Informatica Service
Repository Server Administration Console:
Creation of  new Repositories
Maintainance of Repositories
Repository Manager Tool
o        Creation of Folders, Users, Groups within Repositories
o        Granting Privileges
Designer Tool:
Components of Designer Tool
Pre-defined of  Transformations, Ports, Types of Ports
Source Definition, Target Definition and Mappings
Examples of Pre-defined Transformations
User-defined Transformations
Mapplets
Workflow Manager Tool:
o        Creation of Server(s), Database Connections
o        Creation of Workflow and Tasks
o        Sequential or Concurrent Relation
o        Session and other Tasks Properties
o        Setting up of Informatica Service using Informatica Server Setup Tool
o        Starting Informatica Service/Server
o        Scheduling/Execution of Workflow
o        Monitoring Data Loading Process
o        Tracing Errors
Cube Example from Retail Business Analysis Domain
Using Debugger within Designer Tool