~repack~ - Informatica+powercenter+106

Informatica PowerCenter 10.6 is a major release of the enterprise-grade Extract, Transform, Load (ETL)

Technical Requirements

  • PowerCenter 10.6 or later
  • Multi-core processors (8+ cores recommended)
  • Grid license for distributed execution
  • Ignore errors (continue processing, mark row as error).
  • Treat as warning (log but continue).
  • Abort (stop session).
  1. Check the session log for the bottleneck transformation.
  2. Implement partitioning on the Aggregator.
  3. Switch to a Dynamic Lookup for your dimension loads.
  4. Parameterize your hard-coded values.

1. Enhanced Security and Authentication

Security is the primary driver for many 10.6 upgrades. This version introduced significant enhancements to authentication protocols: informatica+powercenter+106