Informatica PowerCenter Developer Training Course and Workshop in Bangalore, Mysore, Chennai, Hyderabad, Pune, Mumbai, Delhi, Noida, Gurgaon, Kolkata

In Informatica PowerCenter Developer training course delegates will learn to work through the PowerCenter Designer, Workflow Manager, and Workflow Monitor tools while performing tasks such as creating source and target definitions, transformations, mappings, reusable objects, sessions and workflows to extract, transform and load data.

By attending Informatica PowerCenter Developer - Level 1 workshop, delegates will learn to:

Utilize PowerCenter Designer to build mappings that extract data from a source to a target, transforming it as necessary
Deploy PowerCenter transformations to cleanse, format, join, aggregate and route data to appropriate targets
Perform error handling/trapping using PowerCenter mappings
Use PowerCenter Workflow Manager to build and run workflows which execute sessions associated with a mapping and to control data transformation processes.
Design and build simple mappings and workflows based on essential business needs
Complete basic troubleshooting using PowerCenter logs and debugger

By attending Informatica PowerCenter Developer - Level 2 workshop, delegates will learn to:

Understand the Informatica PowerCenter architecture
Determine the structure and use of PowerCenter Parameter Files
Implement user-defined and advanced functions.
Normalize and Denormalize data using PowerCenter
Use the Lookup transformation in Dynamic mode
Call a SQL stored procedure from a PowerCenter mapping
Create and configure a SQL transformation and its two modes of use
Design error handling strategies appropriate for the intended purpose of a workflow
Make use of the PowerCenter source-based, target-based, and user-based transaction control
Utilize constraint-based loading in databases with referential integrity constraints
Use the Transaction Control transformation for data-driven RDBMS transaction control
Determine the proper use of built-in and optional, mapping-design recovery capabilities
Build batch files that use PMCMD and PMREP command line programs
Apply PowerCenter Performance Tuning Methodology
Describe the effect of mapping design on performance and apply these design principles to a mapping
Calculate how much memory a session uses and tune session-level memory Apply partitions, distribute the data and optimize the CPU memory usage

For Informatica PowerCenter Developer - Level 2 : Attending one of the below trainings or having equivalent knowledge / experience.

Informatica PowerCenter: Developer, Level 1
Informatica PowerCenter: Data Integration for Developers

For both the levels :

Developer

An Overview of Informatica PowerCenter

PowerCenter Architecture, Terminology, Tools GUI, Mappings, Transformations, Sessions, Workflows and Workflow Monitor

ETL Fundamentals

Using the Source Analyzer to create flat file and relational Sources
Using the Target Developer to creat flat file and relational Targets
Mapping Designer
Workflow Designer
Monitoring workflows
Previewing Target Data with PowerCenter Designer

Troubleshooting

PowerCenter Log files
Viewing and looking up error messages
Correcting mapping and workflow errors

PowerCenter Transformations, Tasks and Reusability

PC Designer Transformations and Workflow Tasks
Active vs. Passive Transformations
Expression Transformation and Editor
Reusable Designer Transformations

Features and Techniques

Usage of Arrange All and Arrange All Icons
'Autolink' feature
'Select Link Path' feature
Propagation of Port Properties

Joins and Link Conditions

Joins
Clarify Heterogeneous vs. Homogeneous Joins
Joiner Transformation
Source Qualify and joining two relational sources
Executing sessions with Link Conditions

Using the Debugger

Debugger Interface
Creating a break point
'Evaluate the Expression' functionality
Re-Executing mappings

Sequence Generators, Lookups and Additional Workflow Tasks

Sequence Generator definition and use
Lookup Transformations
Varying types of Lookups
Lookup Caching
Flat file Lookups for adding data to relational targets
Multiple Row Return Lookup
Using Aggregators and Expressions
Using the dates Lookup Cache
Utilizing Event Wait, Event Timer and Email Tasks
Usiing a decision task

Update Strategies, Routers and Overrides

Using Update Strategies and Routers for mappings and determining insert/ update logic for a target
Overrides for incremental (daily) loading of the target

Sorting and Aggregation Data Using PowerCenter

Unconnected Lookups
Mapping Parameter/Variables and Mapplets/Worklets
Sorter Transformation
Aggregator Transformation and Aggregate Functions
Unconnected Lookups and how they are called
Mapping Parameters/Variables and initialization priority
Mappets and Worklets
Transformations for record loading
Parameter File Instruction

Mapping Design Workshop

Designing and building mappings for loading an aggregate table
Determining logic for mappings
Velocity Best Practices

Workflow Design Workshop

Designing and building a workflow to load staging tables
Determining the correct logic for a workflow
Velocity Best Practices

PowerCenter Architecture

Describe the components of the Informatica PowerCenter architecture and define key terms
Describe PowerCenter’s optional and built-in high availability features

Parameter Files

Ascertain the use of the IsExprVar property in a mapping.
Determine the structure of a parameter file.
Establish the use of parameter files in mappings and sessions
Describe the flexibility of using parameter files to build mapping expression logic.
Describe the use of a date/time mapping variable, in a parameter file for incremental loading

User-Defined and Advanced Functions

Describe and implement advanced functions
Describe User-Defined functions
Create a public, User-Defined Function to create a standard name formatting function and implement the UDF in the mapping.
Use the AES_Encrypt and Encode functions to encrypt and encode customer data before writing it to flat file.
Debug the mapping using an existing session and observe the results

Pivoting Data

Describe the use of a Normalizer transformation to normalize data
Describe the use of an Aggregator to denormalize data
Normalize data into a relational table
Denormalize data into a Fact table.

Dynamic Lookups

Define Dynamic Lookup
Describe the Dynamic Lookup Cache
Use a Dynamic Lookup to load data into a dimension table.
Use a Dynamic Lookup in tandem with an Update Strategy transformation to keep historic data in a dimension table

Stored Procedure and SQL Transformations

Call a SQL stored procedure from a PowerCenter mapping
Create and configure a SQL transformation in script mode.
Create and configure a SQL transformation in query mode.
Use a SQL transformation to create tables on an “as needed” basis.
Enter a properly formatted query into a SQL transformation.
Locate database errors in the result output of a SQL transformation.

Troubleshooting Methodology and Error Handling

Design error handling strategies appropriate for the intended purpose of a workflow
Identify data errors and load them to an error table.
Describe Update Strategies

Transaction Processing

Describe PowerCenter source-based, target-based, and user-based transaction control with and without the high availability option
Describe constraint-based loading in databases with referential integrity constraints
Load data to a set of tables with a RDBMS Primary-Foreign key relationship

Transaction Control Transformation

Describe the use of the transaction control transformation for data-driven transaction control
Control when data is committed to disk or the target database
Use a transformation variable to create a flag that determines when to commit data to the RDBMS based upon data values

Recovery

Describe workflow and task recovery with and without the high availability option
Recover tasks and workflows that stop, abort, or terminate
Verify that workflow recovery works in a consistent, reliable manner.

Command Line Programs

Describe PMCMD, PMREP, and INFACMD command line functionality
Build batch files that use PMCMD and PMREP command line programs
Use the command line utilities to execute a variety of platform status, query, object export, and workflow tasks

Performance Tuning Methodology

Isolate source, target and engine bottlenecks
Interpret the performance counters
Tune different types of bottlenecks
Run a benchmark test
Run a target bottleneck test
Evaluate the results
Apply best practices in your mappings to optimize performance
Locate session properties that can unnecessarily lower performance.
Inspect and edit mappings for optimal performance design.
Inspect and edit transformations for optimal performance design

Memory Optimization

Tune session-level memory
Tune transformation caches
Calculate how much memory a session uses
Become familiar with PowerCenter Performance Counters
Edit session memory limits
Edit transformation cache memory properties
Calculate memory cache sizes for transformations

Performance Tuning: Pipeline Partitioning

Apply partition points to efficiently utilize your CPU
Partition your data to efficiently utilize your CPU
Distribute your partitioned data to preserve functionality while optimizing your CPU
Optimize your memory usage according to your partitioning strategy

Encarta Labs Advantage

One Stop Corporate Training Solution Providers for over 4,000 Modules 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 Developer

COURSE AGENDA