This classic four-day instructor-led Informatica PowerCenter Level 1 Developer training course introduces delegates to Informatica PowerCenter through lecture and hands-on labs. The Level 1 course is designed for ETL Developers who have no or little experience using this comprehensive PowerCenter tool. The PowerCenter software is used by Developers to create, execute, monitor and schedule ETL processes.

Course Duration

  • Four days of instructor led training
  • 60% lecture, 40% hands-on

Pre-requisites

  • SQL knowledge
  • Understanding of data warehouse fundamentals

Audience

  • Data integration / ETL developers

Agenda

  • Informatica PowerCenter Overview
  • ETL Essentials: How to use Source Analyzer, Target Developer, Mapping Designer, Workflow Designer, Workflow Monitor and PowerCenter Designer
  • Trouble Shooting: PowerCenter Log files
  • PowerCenter Transformations & Tasks
  • Apply formatting logic with Reusability Designer
  • How to Join and Link Conditions
  • Caching & Lookups
  • Sequence Generators
  • Update Strategies, Routers and Overrides
  • How to use the Debugger
  • Sorter, Aggregator, Unconnected Lookups
  • Mapping Parameter & Variables
  • Maples & Worklets
  • Hands-On Case study: Mapping Design & Velocity Methodology Best Practices
  • Hands-On Case study: Workflow Design & Velocity Methodology Best Practices