# 5/1, Rich Home, 3B (Third Floor),

Richmond Road, Bangalore - 560025

Tel: 080-4126000 /01 /02 /03

Mobile: +91-9243607538, +91-9886148509

CONTACT US

Informatica

    Training Overview

    • Course Duration: 45 Days (Regular Program) / 25 Days (Fast Track) / 10 Weekends (Weekend Batch)

    • Who Should Join: Any graduate or postgraduate or professional having basic knowledge of computer and database
     
    "Informatica The Data Integration" Course Ware
     

    Chapter 1: Data Warehousing Introduction 

     

    • Basic Concepts
    • Facts and Dimensions
    • Types of Schema

    Chap 2: Informatica Introduction

     

    • Introduction to ETL 
    • Informatica Integration Service Architecture Overview
    • Informatica Corporation Products

    Chap 3: Informatica Power Center Client

     

    • Introduction to Power Center Client
    • Client Tools (Repository Manager, Designer, Workflow Manager, Workflow) 

     

    Chap 4: Power Center Tools

     

    • Introduction to Designer
    • Introduction to Workflow Manager
    • Introduction to Workflow Monitor


    Chap 5: Transformation Basic Concepts

     

    • Transformation Objects
    • Informatica Power Center

    Chap 6: Informatica Transformation Basic Concepts

     

    • Types of Transformation (Active and Passive Transformation & Connected and Unconnected Transformation)
    • Power Center Components and Transformation (Source Qualifier, Expression, Filter, Sorter, Aggregation, Joiner, Look up, Update Strategy, Router, Sequence Generator Transformation, Source and Target Overrides, Rank Transformations, Update Strategy Transformation)

    Chap 7: Slowly Changing Dimensions

     

    • SCD Type 1 Mapping, Design and Implementation 
    • SCD Type 2 Mapping, Design and Implementation
    • SCD Type 3 Overview

    Chap 8: Mapping Designer

     

    • Create Mapping
    • Execute Mapping
    • Advance Mapping Techniques
    • Error Handling
    • Performance Tuning
    • Stored Procedure Transformation

    Chap 9: Workflow Manager

     

    • Create Workflow
    • Advance Workflow Techniques

    Chap 9: Advanced Concepts 

     

    • Parameters and Variables
    • Incremental Aggregation
    • Self Join
    • Dynamic Look Up Cache
    • Mapplets
    • Workflow Configuration and Techniques 
    • Session Configuration and Work Lets
    • Workflow Scheduler
    • Reusable Transformation
    • Work Lets
    • Debugger
    • Fact Loading
    • Partitions

    Chap 10: Extras

     

    • SQL / PL-SQL Basics
    • Unix Question
    • Interview Questions

    Ph: +91- 080 - 41226000 / 01 / 02 / 03
    Email:  This email address is being protected from spambots. You need JavaScript enabled to view it.

     

    Query

    Email  
    Subject  
    Name  
    Phone  
    Message