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.
- Datawarehouse Concepts
- SQL Introduction
- Informatica Overview
- Designer Intro
- 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