Informatica Training

Informatica Syllabus

 

Introduction Of Data Warehouse

  • What Is Data Warehouse?
  • Data Warehouse Architecture
  • Explain OLTP, OLAP
  • Explain Schemas

First Steps

  • What Is Etl?
  • What Is Informatica?
  • Informatica Architecture Overview
  • Explain Informatica Power Center Components
    • Designer
    • Repository Manager
    • Workflow Manager
    • Workflow Monitor
    • Power Center Admin Console

Sources

  • Relational Sources(Data Bases)
  • Files Sources(Flat File, Xml, Cobol)

Targets

  • Relational Targets(Data Bases)
  • Files Targets

Transformations

  • What Is Transformation
  • Type Of Transformation
    • Active Transformations
    • Passive Transformations
  • Expression Transformation
  • Filter Transformation
  • Router Transformation
  • Sorter Transformation
  • Rank Transformation
  • Source Qualifier Transformation
  • Aggregator Transformation
  • Joiner Transformation
  • Sequence Generator Transformation
  • SQL Transformation
  • Stored Procedure Transformation
  • Lookup(Different Type Of Lookup) Transformation
  • Union Transformation
  • Normalizer Transformation
  • Update Strategy Transformation
  • Slowly Changing Dimension
  • SCD Type-1
  • SCD Type-2(Date, Flag And Version)
  • SCD Type-3

Workflow Manager

  • Create Reusable Tasks
  • Workflows, Sessions And Worklets
  • Task
  • Session
  • Decision Task
  • Control Task
  • Event Wait Task
  • Timer Task
  • Monitoring Workflows And Debugging Errors

Indirect Loading

Constraint Based Load Ordering

Target Load Plan

Worklet, Mapplet

Reusable Transformation

Migration

  • Xml Migration & Folder Copy

Scheduling Workflow

Parameter and Variables

Xml Source, Target and Transformations

Performance Tuning

Partition

Quick Enroll