Informatica PowerCenter – Developer basics

Course objectives

Learning the basics of ETL based on the Informatica PowerCenter platform. Upon training completion, the participant can implement a complete ETL proces.

Benefits

• Workshop participants will learn about:
  • ETL basics
  • The concept of dimensions, measures and facts
  • Schemes: star, snowflake, constellation, starflake
  • Informatica PowerCenter platform and tools included in it
  • Creating and managing ETL processes
  • Transformations
  • Sequences
  • Lookup
  • Combining data from different sources
  • Routing
  • Parameters and their impact on process optimization
  • Data update strategies and their selection
  • Data Aggregations

Training scope

• ETL basics
• Overview of the Informatica PowerCenter platform
• Selection of source and target data
• Transformations, mappings, maplets
• Sharing and reusability
• Data Linking
• Conditions
• Functionalities and techniques
• Sequences
• Lookup
• Caching
• Strategies for updating, separating and overwriting data
• Sorting, aggregations, variables / parameters and mapplets

Audience

All individuals involved in software development process using Informatica PowerCenter. Developers, testers and people who want to explore the platform and create an ETL process for the needs of data warehouses, thematic warehouses and aggregated data sets for reporting systems.