INFORMATICA Course Content

 
Introduction
  • Overview
  • Basic Definitions
  • Informatica products
  • Informatica Architecture
  • Tools and their roles
  • Folders-Sub folders
  • Power center / Power mart
 
Infomatica Designer - Introductiion
  • Introduction to Designer
  • Logon to Designer
  • Designer interfaces
  • Designer Tools
  • Defining Sources
    • Database as a source
    • Flat File sources
  • Defining Targets
  • Importing from database
  • Creating a new target
  • 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 to join Data
  • Filter Transformation
  • Expression Transformation
  • Sequence Generator Transformation
  • Rank Transformation
  • Router Transformation
  • Aggregator Transformation
  • Joiner Transformation
  • Stored Procedure Transformation(Connected and Unconnected)
  • Union Transformation
  • XML Transformation
  • Mapping Wizards
  • Implementing Type-I,Type-II,Type-III Mappings
 
Informatica - Workflow Manager
  • Workflow Introduction
  • Tasks
  • Workflow tools
  • Connetions
  • Defining tasks
    • Command Tasks
    • Email Task
    • Session Task
    • Link Conditions
    • Event Wait & Event Raise
  • Setting Properties of Session Task
  • Creating Workflow
  • Starting Workflow
  • Monitoring Workflow
 
 
Informatica Advanced Features
  • Incremental Aggregation
  • Mapplet Implementation
  • Target Load Plan
  • Constraint Based Loading
  • Mapping Variable
  • Session Parameters
  • Link Conditions
  • Reusable Transformation
  • Task and Types of Tasks
  • Work let and Types of work lets
  • Scheduling Workflow
  • Control flow using Command task and event wait task
  • Incremental Loading