Introduction to Data warehousing

• What is Data warehousing?
• Who needs Data warehouse?
• Why Data warehouse is required?
• Types of Systems

(i) OLTP

(ii) DSS

• Maintenance of Data warehouse
• Data warehousing Life Cycle
• Data warehousing Testing Life Cycle

Data warehousing Architecture

• Source
• Integration Layer
• Staging Area
• Targets
• Analysis & Reporting
• ODS

Data Modeling

• Introduction
• Different phases of Modeling

Multi Dimensional Modeling

• What is a Dimension?
• What are Facts?
• Multi Dimensional Model
• Hierarchies
• OLAP
• MOLAP
• ROLAP
  
• HOLAP
• Cubes and its Functions
• Star Schema
• Fact Table
• Dimensional Tables
• Snow flake Schema
• Factless Fact Table
• Confirmed Dimensions

Informatica 8.6
Introduction to Informatica

• Overview
• Basic Definitions
• Informatica Products
• Informatica Architecture
• Tools and their roles
• Folders - Sub Folders

Informatica Designer - Introduction

• Introduction to designer
• Designer interfaces
• Designer tools
• Defining Sources

(i) Database as a source
(ii) Flat Files sources

• Defining Targets

(i) Importing from database
(ii) Creating a new target
(iii) Creating target database objects
Informatica Designer

• Mapping Introduction
• Source Qualifier
• Ports
• Mapping - Table to Table
• Mapping flat file to Table
• Connected / Unconnected Transformations
• Active and Passive Transformations
• Source Qualifier Transformation
• SQL override in Source Qualifier Transformation
• Mapping Source Qualifier as Filter
• Source Qualifier to join data
• Filter Transformation
• Expression Transformation
• Sequence Generator Transformation
• Rank Transformation
• Router Transformation
• Aggregator Transformation
• Joiner Transformation
• Stored Procedure Transformation
• Connected and unconnected Transformation
• Union Transformation
• XML Transformation
• Mapping Wizards
• Implementing Type-I, Type-II and Type-III mappings

Informatica Workflow Manager

• Workflow Introduction
• Tasks
• Workflow Tools
• Connections
• Defining Tasks
  
  • Command Task
  • Email Task
  • Session Task
  • Link Conditions (v) Event Wait & Event Raise
• Setting properties of Session Task
• Creating Workflow
• Starting Workflow
• Monitoring Workflow

Informatica Advanced Features

• Incremental Aggregation
• Mapping Analyst for Excel (MAE)
• Push-down Optimization
• Mapplet Implementation
• Target Load Plan
• Constraint Based Loading
• Mapping Parameters
• Mapping Variables
• Session Parameters
• Link Conditions
• Meta Data Backup & Restore
• Copying Repository
• Deleting Repository Contents