Informatica PowerCenter - Data Integration for Developers Training Course and Workshop in Bangalore, Mysore, Chennai, Hyderabad, Pune, Mumbai, Delhi, Noida, Gurgaon, Kolkata

The Informatica PowerCenter - Data Integration for Developers training course provides the skills and knowledge necessary to design, build, test, and maintain real-world data integration systems with PowerCenter's workbench tools. you will learn to create and combine PowerCenter objects such as source and target definitions, data transformations, mappings, sessions, and workflows in order to accomplish their project goals while using best-practice methodology.

By attending Informatica PowerCenter - Data Integration for Developers workshop, delegates will learn to:

Use the PowerCenter Designer interface to design data transformations.
Manage a variety of source and target definitions.
Filter, join, aggregate, categorize, merge, and apply expression logic to data without writing SQL.
Monitor and repair PowerCenter Sessions and Workflows.
Troubleshoot mapping problems with the debugger.
Leverage object reusability (build-once, use everywhere)
Benefit from specific Agile Data Integration best practice techniques.

Developers

Introduction to PowerCenter

How PowerCenter performs data integration
Advantages of code-free and SQL-free development
Informatica architecture
PowerCenter components and applications
PowerCenter object types

Folders, Sources, and Targets

PowerCenter folder types
Folder best practices
Source definition types and methods of creation
Target definition types and methods of creation
Benefits of object shortcuts

Design Objects

Fundamental mapping components
Transformation types
Mapping types
PowerCenter expressions and port types
Filtering records

File Lookups

Fundamentals of the Lookup transformation
How to create a lookup on file data
Joining heterogeneous data
Multi-return lookups
Bypassing transformations

Relational Lookups

How to create a lookup on relational data
Understanding lookup connectivity
Port default values
Variable ports
Refreshing mapping metadata

Database Joins in PowerCenter

Getting the database to join data
Reusable transformations
Target Load Plan
Multi-pipeline mappings
Workflow link conditions

Workflow Logic

Using Session pre-defined variables
Using Decision Tasks
Using Email Tasks
Sending email from within a Session

Merging, Routing, and Sorting Data

Merging mapping pipelines
Removing duplicate records
Classifying data with the Router transformation
Renaming Source Qualifier ports

Command Tasks

Running command line statements within a Workflow
Lookup caching properties
Persistent lookup caches
Aliasing a lookup port

Debugging

When to use the debugger utility
Launching and configuring the debugger
Debugger features and techniques

Parameterization

How and when to parameterize values and properties
Using a parameter file
When to use an unconnected lookup
Using a Sequence Generator transformation

Updating Database Tables

How to update and delete from relational database tables
Perform insert-else-update logic with the Update Strategy transformation
Understanding built-in connection variables
Creating and using Worklets
Timer Tasks
Control Tasks

Mapplets

Creating and using Mapplets
Mapplet types and limitations
Aggregator transformations

Mapping Design Workshop

Encarta Labs Advantage

One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
All courses are delivered by Industry Veterans
Get jumpstarted from newbie to production ready in a matter of few days

Trained more than 50,000 Corporate executives across the Globe
All our trainings are conducted in workshop mode with more focus on hands-on sessions

Informatica PowerCenter Data Integration for Developers

COURSE AGENDA