Informatica PowerCenter Training in Chennai

Informatica Powercenter training provided through Online and Classroom modes by our expert trainers with hands-on exercises – highly practical oriented course. The overview of the course content is provided below. If need the customized or detailed course content mail us at info@blackcloud.in . 

Informatica PowerCenter for Developers training - Course Overview

Concepts

  • Data Warehouse Introduction
  • Data Integration Concepts
  • Informatica Architecture
  • New Features in Informatica 10.x
  • PowerCenter Components

Starting PowerCenter

  • Creating a Folder
  • Assign permissions to folder
  • Flat file source definition
  • Relational target definition

Basic Transformations

  • Source Qualifier
  • Homogenous Join
  • Multiple Pipelines
  • Expression Transformation
  • Filter Transformation
  • Active / Passive Transformations

Designer Techniques

  • Mapping Designer Features
  • Developer Techniques
  • Workflow scheduling
  • Indirect Load from File list
  • Reusable Transformations
  • Homogenous / Heterogeneous sources

More Transformations & Techniques

  • XML Source definition
  • Join Transformation
  • Lookup Transformation
  • Shortcuts and Shared Folders
  • Lookup Cache Management
  • Mapping Debugger
  • Break Points
  • Surrogate Keys
  • Sequence Generator Transformation
  • Relational source definition

Advanced Transformations

  • Sorter Transformation
  • Aggregator Transformation
  • Pre Sorted option
  • Self-join mapping
  • Router Transformation
  • Data driven and other Data Load Options
  • Update Strategy Transformation
  • Advance Features and Techniques
  • Advanced Lookup options
  • Dynamic Lookup Cache

Session features

  • Flat file target definition
  • Overrides for Source and Target
  • Error Logging
  • Parameters and Variables
  • Unconnected Lookup
  • Target Load Order Plan
  • Fact Table Load
  • Mapplets

Workflow

  • Parameter Files
  • PMCMD commands
  • Workflow Variables
  • Link conditions
  • Work flow tasks
  • Worklets
  • Reusable Tasks
  • Session Configuration

Repository Manager

  •  Import / Export Objects and Metadata

Best Practices

Checking...

Ouch! There was a server error.
Retry »

Sending message...

Enquiry Form

Fill in the form below and we will be in touch soon

Our Services

Connect with us

  • Opens in a new tab
  • Opens in a new tab