Institute Address :

B1, 3rd Floor, Eureka Court,
Near Image Hospital, Ameerpet,
Hyderabad, India

Contact Details:

Phone No : 91+7207070872 / 9700446467
Email ID : onlinetrainingfromindia@gmail.com
onlinetraining@onlinetrainingfromindia.com

Online Training Enquiry Form

Security-Code reload security code

Informatica 9 Online Training
Course Duration - 30hrs

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
Online Training