top of page

Informatica Powercenter 9.x 

Prerequisite for this course

  • SQL beginner course

  • Unix basis commands

  • Data warehouse basics

Installation

  • Pre-build VMware setup

  • Informatica Client-Server setup guide on personal system

Transformations

  • What Is Transformation

  • Types of Transformation

    • Active Transformations

    • Passive Transformations

  • Ports in informatica

  • Connection setup in designer and workflow manager

  • 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

  • Transaction control transformation

  • Normalizer Transformation

  • Update Strategy Transformation

Implementations

  • SCD Type-1

  • SCD Type-2(Date, Flag and Version)

  • SCD Type-3

  • Incremental Aggregation

  • Change data capture

Workflow Manager

  • Create Reusable Tasks

  • Workflows, Sessions

  • Task

  • Session

  • Link task

  • Decision Task

  • Control Task

  • Event Wait Task

  • Timer Task

  • Monitoring Workflows and Debugging Errors

Advanced topics

  • Indirect Loading

  • Constraint Based Load Ordering

  • Target Load Plan

  • Worklet, Mapplet

  • Session properties

  • Reusable Transformation

  • Migration

  • Scheduling Workflow

  • Parameter and Variables

  • Performance Tuning

  • Partition

Informatica Intelligent cloud services – Introduction and roadmap

  • Informatica Cloud Overview

  • Informatica Cloud Secure Agent and Architecture

  • Creating Connections

  • Data Synchronization Application

  • Data Replication Application

  • Cloud Mapping Designer

  • Task flows

  • Performance and Scalability

bottom of page