Data Smart Parallelism

• Improve performance by automatically aligning PowerCenter partitions with database table partitions
• Leverage PowerCenter’s parallel engine that dynamically realigns data partitions for set-oriented transformations to automatically guarantee data integrity

Session Design Tools

• Create user-defined partitioning schemes quickly and easily
• Use a graphical partitioning map for determining the best partitioning points
• Gather statistics on configurable session options, such as error handling, recovery strategy, memory allocation, and logging, to maximize performance

Integrated Monitoring Console

• Gather session statistics, such as throughput, rows/second, error details, and performance optimizations, to identify potential bottlenecks and recognize trends
• View all session execution and dependency details

Multiple Partition Schemes

• Support parallelization through multiple mechanisms including key range, hash algorithm-based, round robin, or file partitions
• Support parallelization through concurrent processing of specified partitions along the data transformation pipeline to maximize data throughput