Goals
- Describe the PowerCenter 9x architecture
- Develop mappings and workflows using best practices
- Use the main transformations of mappings and workflow tasks
- Execute and Monitor workflows
- Know how to interpret error messages from execution logs
- Know how to debug flows and adapt solutions
Program
Explain the purpose of PowerCenter
Define the vocabulary used PowerCenter
Introduce the components of PowerCenter
Create sources and targets from flat files and relational tables
Create a mapping using sources and targets
Use links to connect ports
Create a simple workflow and link its tasks
Execute a workflow, monitor its execution and verify the results
Use the Expression transformation to perform calculations on data
Use the Filter transformation to delete records based on a user-defined condition
Sort a set of records according to one or more fields in the Sorter transformation
Calculate values according to a key in the Agregator transformation
Use a Source Qualifier transformation to implement a homogeneous join
Use a Joiner transformation to implement a heterogeneous join
Use a Union transformation to merge multiple records into one
Duration
5 days
Price
£ 2980
Audience
Project manager – Developers
Prerequisites
Have knowledge of Boolean logic (AND, OR) and relational operations (Joins, Aggregation …)
Reference
BUS100369-F
Use the Lookup transformation to get additional information about a record
Use a Router transformation to split a data flow into multiple groups
Use an Update Strategy transformation to determine how a target should be populated (insert / update / delete)
Declare and use variables and mapping parameters
Create and use reusable transformations
Use a disconnected Lookup to provide data on a simple case
Use shared objects (or shortcuts)
Use the debugging tool to unlock and test a mapping
Use the object dependency manager
Create mapplets and use them in existing mappings
Declare and use workflow variables and parameters
Use conditions on links and execution decision tasks
Explain the purpose of the pmcmd command Correctly
use bulk and normal modes
Schedule workflow executions
Apply a variety of best practices in order to effectively develop on PowerCenter
Exporter and import PowerCenter flows on an environment
Sessions
Contact us for more informations about session date