Process Massive Data Volumes With High Performance

The Informatica PowerCenter Partitioning Option helps IT organizations take advantage of parallel data processing in multiprocessor and grid-based hardware environments. This option increases Informatica PowerCenter's performance with a thread-based architecture and automatic data partitioning capabilities. The option executes optimal parallel sessions by dividing data processing into subsets which run in parallel and are spread among available CPUs in a multiprocessor system.

  • Maximize return on IT investments by scaling hardware and software to handle large volumes of data and users
  • Boost IT productivity by reducing the time spent on configuration and performance tuning tasks
  • Optimize system performance in response to changing business requirements

Informatica PowerCenter Partitioning Option Key Features

  • Data smart parallelism that improves performance by automatically aligning Informatica PowerCenter partitions with database table partitions
  • Guaranteed data integrity by leveraging Informatica PowerCenter’s parallel engine to dynamically realign data partitions for set-oriented transformations
  • Session design tools for creating partitioning schemes, determining the best partitioning points, and gathering statistics on error handling, recovery strategy, memory allocation, and logging
  • Integrated monitoring console for gathering session statistics, such as throughput, rows/second, error details, and performance optimizations, to identify potential bottlenecks and recognize trends
  • Multiple partition schemes to support parallelization through key range, hash algorithm-based, round robin, or file partitions and through concurrent processing of partitions along the data transformation pipeline to maximize data throughput