EncartaLabs

Informatica PowerCenter Developer

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

COURSE AGENDA

Informatica PowerCenter Developer - Level 1
(Duration : 4 Days)

1

An Overview of Informatica PowerCenter

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

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
3

Troubleshooting

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

PowerCenter Transformations, Tasks and Reusability

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

Features and Techniques

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

Joins and Link Conditions

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

Using the Debugger

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

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
9

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
10

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
11

Mapping Design Workshop

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

Workflow Design Workshop

  • Designing and building a workflow to load staging tables
  • Determining the correct logic for a workflow
  • Velocity Best Practices
Informatica PowerCenter Developer - Level 2
(Duration : 4 Days)

1

PowerCenter Architecture

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

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
3

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
4

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.
5

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
6

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.
7

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
8

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
9

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
10

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.
11

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
12

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
13

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
14

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

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top