Informatica PowerCenter (ETL)

Module 1: Informatica PowerCenter Architecture

• PowerCenter components: Repository, Server, Client tools
• Repository Service, Integration Service, and Reporting Service
• PowerCenter Client tools: Designer, Workflow Manager, Monitor
• Installing PowerCenter Developer edition
• Repository Manager: creating and managing repositories
• PowerCenter certification pathway

Module 2: Source & Target Definitions

• Source Analyzer: importing flat file, relational, and XML sources
• Target Designer: defining relational and flat file targets
• Source Qualifier transformation: SQL override and filter
• Creating relational targets from source definitions
• Flat file source configuration: delimited and fixed-width
• XML source and target configuration

Module 3: Core Transformations

• Expression transformation: calculated columns and logic
• Filter transformation: row-level filtering
• Aggregator transformation: GROUP BY and aggregate functions
• Joiner transformation: joining heterogeneous sources
• Sorter transformation: data ordering
• Sequence Generator: surrogate key generation

Module 4: Advanced Transformations

• Lookup transformation: cached and uncached lookups
• Router transformation: multi-condition routing
• Union transformation: combining multiple pipelines
• Normaliser transformation: handling repeating groups
• Rank transformation: top-N and bottom-N rows
• Update Strategy: insert, update, delete, reject logic

Module 5: Mappings & Reusability

• Mapping design best practices
• Reusable transformations: creating and using shared objects
• Mapplets: encapsulating reusable mapping logic
• Mapping parameters and variables
• Dynamic lookups and dynamic targets
• Mapping debugging with data viewer

Module 6: Workflow Design

• Workflow Manager: sessions, tasks, and links
• Session task: mapping execution configuration
• Decision task and Assignment task
• Command task: running shell scripts in workflow
• Timer task: scheduled and time-based execution
• Email task: notifications on success and failure

Module 7: Performance Tuning

• Source qualification pushdown optimisation
• Partition strategies: database, hash, key range, round-robin
• Caching strategies: static and dynamic lookup caches
• Buffer memory and DTM buffer configuration
• Pushdown optimisation to source and target databases
• Incremental extraction and CDC patterns

Module 8: Administration, Monitoring & Migration

• PowerCenter Repository Manager: folder and object management
• Workflow Monitor: session and workflow execution tracking
• Error handling: bad file, reject file, and session log analysis
• pmrep: command-line repository management
• pmcmd: command-line workflow execution
• Migrating mappings between environments with deployment groups

Our Informatica PowerCenter instructors are Informatica-certified ETL architects with deep enterprise data warehousing experience in financial services, retail, and healthcare. They have designed high-performance PowerCenter environments processing billions of rows and bring expertise in partitioning strategies, pushdown optimisation, and large-scale DW project delivery.