10.6: Informatica Powercenter

The primary tool used to create mappings and define the logic for data flow.

Version 10.6 introduces "Persistent Lookup Cache" with compression. If you have a static dimension table (e.g., Date dimension), configure the lookup transformation to cache to disk with GZIP compression. This reduces memory pressure by 70% and speeds up subsequent lookups dramatically. informatica powercenter 10.6