Data Warehousing Basic Concepts

• Data Warehouse Definition,
• Reasons  for using, uses
• Characteristics of DWH
• OLTP Vs OLAP Databases

Implementation Methodology

• Kimball Methodology
• Inmon Methodology

Types of Loads

• First Time Load
• Full Load
• Incremental Load

Data Marts and Star Schema Design

• Definition of Star Schema
• Design of Dimension and Facts
• Snow Flake Star Schema
• Slowly Changing Dimensions
• Non Additive Facts
• Conformed Dimensions

INFORMATICA   9.5
Informatica Power Center

• Basic Concepts of Informatica
• Overview Basic Definitions
• Informatica Products, Architecture
• Tools and their Roles
• Power Center Vs Power Mart
• Understanding Informatica Server Configuration

Informatica Designer

• Basic Concepts
• Using the Designer
• Working with Sources
• Working with Flat Files, Targets
• Mappings, Transformations, Mapplets
• Working with Debugger
•  Implementing Type 1, Type2, Type 3 Mappings
• Loading the data into different fact  tables

Working with Transformations

• Aggregator Transformation
• XML Transformation
• Expression, Look up Transformation
• Rank, Router, Filter, Sequence Generator
• Sorter Transformation
• Source Qualifier Transformation
• Stored Procedure Transformation
• Transaction Control Transformation
• Joiner, Union Transformation
• Java Transformation
• SQL Transformation
• XML Source Qualifier
• Update Strategy Transformation
• Mapplet Input Transformation
• Mapplet Output Transformation
• Connected Vs Unconnected Transformations

Creating Work flows

1. Understanding the server Architecture
2. Working with Workflows
3. Working with Tasks Assignment , Command, Decision, Control, Event Raise Event Wait, Timer , Email, Session Task
4. Working with Worklets
5. Working with Sessions
6. Understanding Commit Points
7. Understanding Commit Points
8. Monitoring Workflows
9. Session Parameters
10. Parameter files
11. Using Incremental Aggregation

Real-Time Implementation with Informatica

• Performance Tuning
• Using Incremental Aggregation
• Incremental Extraction with Mapping Parameters and Variables
• Session parameters and variables
• Session and Workflow Properties Reference
• Configuring Session Caches Lookup, Aggregate, Sort, Joiner Caches
• Constraint Based Loading
• Target Load Plans
• Dynamic Lookup