Apps2Fusion offers Informatica Training Programs to developers who are new to the world of Informatica PowerCenter 9.x. By taking up Informatica PowerCenter 9.x Developer Training you will become the PowerCenter Designer, Workflow Manager, and Workflow Monitor tools, performing tasks such as creating transformations, mappings, reusable objects, sessions and workflows to extract, transform and load data. You will be able to develop cleansing, formatting, sorting and aggregating procedures. You will learn how to use routers, update strategies, parameters /variables and overrides. You will know about many different types of lookups, such as cached, persistent, dynamic and multiple row returns. Workflow tasks will be created to define a set of instructions for executing the ETL.
Preview
By the end of this training you will learn to:
Use Informatica Support to resolve questions and problems with PC9.x.
Use PowerCenter 9.x Designer to build mappings that extract data from a source to a target, transforming it as necessary.
Use PowerCenter transformations to cleanse, format, join, aggregate and route data to the appropriate targets
Perform error handling/trapping using PowerCenter mappings
Use PowerCenter 9.x Workflow Manager to build and run a workflow which executes a sessions associated with a mapping
Design and build simple mappings and workflows based on essential business needs.
Perform basic troubleshooting using PowerCenter logs and debugger.
Course Contents
Day 1
An Overview of Informatica PowerCenter 9
Overview of PowerCenter covering areas such as the
Architecture, Terminology, Tools GUI, Mappings,
Transformations, Sessions, Workflows and Workflow Monitor
ETL Fundamentals
How to create:
- Flat file and relational Sources using the Source Analyzer
- Flat file and relational Targets using the Target Developer
- Mappings using the Mapping Designer
- Workflows using the Workflow Designer
Monitor the workflow using the Workflow Monitor
Preview Target Data using the PowerCenter Designer
Trouble Shooting
Understand PowerCenter Log files
Use PC log files to:
View and look up error messages
Correct mapping and workflow errors
Day 2
PowerCenter Transformations, Tasks and Reusability
Define list of PC Designer Transformations and Workflow Tasks
Clarify Active vs. Passive Transformations
Use the Expression Transformation and Editor in a mapping which applies a file list to load multiple flat files into a stage table utilizing expression and filter transformations to format and screen erroneous customer data
Use Reusable Designer Transformations to apply same formatting logic to Employee records
Joins and Link Conditions
Define Joins
Clarify Heterogeneous vs. Homogeneous Joins
Use a Joiner Transformation to join relational and flat file sources
Use the Source Qualify to join two relational sources
Make use of Link Conditions to execute one session when the first finishes successfully.
Using the Debugger
Outline Debugger Interface
Show creation of a break point
Show ‘Evaluate the Expression’ functionality
Re-Execute mapping with different values
Day 3
Sequence Generators, Lookups and Caching
Define the Sequence Generator
Define the Lookup Transformation
Understand the different types of Lookups
Clarify Lookup Caching
Use a Flat File Lookup to add data to a relational target.
Build a Dates Lookup Cache for use in determining start and end dates of target records
Utilize Event Wait, Event Timer and Email Tasks to wait for flat files and email users upon successful/failed load.
Update Strategies, Routers and Overrides
Build a mapping that uses Update Strategies and Routers to determine insert/update logic for a target. Overrides will be used for incremental (daily) loading of the target.
Sorter, Aggregator, Unconnected Lookups, Mapping Parameter/Variables and Mapplets/Worklets
Define Sorter Transformation
Detail Aggregator Transformation and Aggregate Functions
Explain Unconnected Lookups and how they are called.
Describe Mapping Parameters/Variables and initialization priority
Outline Mappets and Worklets
Use these Transformations to create a mapping which loads records from warehouse Dimension tables to a Fact table.
Day 4
Workflow Variables and Tasks
Use PC workflow variables to pass information from one point in a workflow to another
Use an Assignment task to establish the value of a workflow variable within a workflow
Use a decision task to set criteria by which the workflow will decide which execution branch to follow
Parameter Files and Command Tasks
Use a Parameter file to make mappings and workflows more flexible by defining values for mapping variables, source files, database connections for sessions and workflow log files
Use Command Tasks to run scripts to rename and move files
Dynamic Lookups and Error Logging/Handling
Use Dynamic Lookup, Router and Update Strategy in a mapping do a lookup on the target table and determine if the record should be an insert, update or logged to a file as an error.
Use PowerCenter Best Practices to create a mapping to trap fatal and non-fatal errors.
Day 5
More Lookup Functionality
Create a Multiple Row Return Lookup, use Aggregators and Expressions to count the number of orders a Customer has as
well as total the sales for that customer. Add those values to a target.
Mapping Design Workshop
Business requirement details will be provided so that the student can design and build their own mapping necessary to load a Promotions Aggregate table. The workshop will provide Velocity Best Practices documents that can be used to determine the correct logic for the mapping
Workflow Design Workshop
Business requirement details will be provided so that the student can design and build their own workflow necessary to load all staging tables in a single workflow. The workshop will provide Velocity Best Practices documents that can be used to determine the correct logic for the workflow.
Apps2Fusion Articles 