Informatica PowerCenter is a widely used Extraction, Transformation and Loading (ETL) tool used in building enterprise Data-Warehouses. The components within Informatica PowerCenter aid in extracting data from its source, transforming it as per business requirements and loading it into a target Data-Warehouse/Data-Mart.

The course covers:

  • Datawarehouse Concepts

  • SQL Introduction

  • Informatica Overview

  • Designer Intro

  • Transformation

  • Workflow Manager/ Monitor

  • Week 1 - Datawarehouse Concepts
    Introduction to warehouse, OLTP, ETL, OLAP, Data Modelling, Normal Forms, Star Schema, Snowflake Schema, Types of facts and dimension, slowly changing Dimension

  • Week 2 - SQL Introduction
    Introduction to SQL, Data types, Constraints, Select, Joins, Sub Queries, Performance Tuning tips

  • Week 3 -Informatica
    Introduction to ETL, ETL Architecture, Informatica Client tools

  • Week 4 - Designer Tool
    Login to designer, defining sources, targets, Importing from databases, flat files, folders, mapping design, Direct load, Indirect load, ports and variables.

  • Week 5 - Transformations
    Connected/unconnected lookup, Active/Passive transformations, Source Analyzer, Filter, Sequence, Rank, Router, Aggregator, Joiner, Sort, Mapplet, Slowly Changing Dimensions, type 1, 2, 3