Back to Courses

Informatica PowerCenter

Complete Informatica PowerCenter training covering data warehousing concepts, ETL architecture, all core and advanced transformations, mapping/workflow development, performance tuning, and change data capture. Includes ten days of dedicated real-time scenario practice, Oracle 11g + Informatica 10.4 installed on your system, and interview preparation covering SQL and Informatica.

4.6 (298 reviews)
2.5 Months
1,345 enrolled
Batch starts: 1 October

What You'll Learn

DWH Concepts to Advanced ETL Development
17 Transformations, Hands-on
Real-Time Scenarios Practice for 10 Days
Oracle 11g + Informatica 10.4 Installed on Your System
Performance Tuning & Push-down Optimization
Interview Q&A (SQL & Informatica)

Course Syllabus

Module 1: Module 1: DWH Concepts

  • Introduction and Definition of Data Warehousing
  • Architecture: Sources, Transformations, and Targets
  • Data Acquisition Process: Data Extraction, Transformations, and Loading
  • Data Warehousing Approaches
  • Staging Area, Metadata, Repository, and Data Mart
  • Data Modelling
  • Differences between OLTP and OLAP (DSS) Systems
  • Operational Data Store (ODS)
  • Business Intelligence
  • Star Schema Design and Snowflake Schema
  • Junk Dimension, Confirmed Dimension, Fact-less Fact Table, Types of Facts
  • Slowly Changing Dimensions (SCD)

Module 2: Module 2: Informatica Concepts

  • Introduction to Informatica
  • ETL Process in Informatica
  • ETL Naming Conventions of Different Vendors
  • Informatica Products: PowerCenter and PowerMart
  • Informatica Software: Server and Client
  • Informatica Components and Sub-components
  • Active and Passive Transformations
  • Transformation Types
  • Connected and Unconnected Transformations
  • ETL Implementation Tasks in Informatica
  • Informatica Low-Level Architecture (by Sampath Goud)

Module 3: Module 3: Transformations

  • Source Qualifier
  • Filter Transformation
  • Expression Transformation
  • Sorter Transformation
  • Aggregator Transformation
  • Joiner Transformation
  • Router Transformation
  • Lookup Transformation
  • Stored Procedure Transformation
  • Union Transformation
  • Sequence Generator Transformation
  • Rank Transformation
  • Transaction Control Transformation
  • XML Source Qualifier
  • Normalizer Transformation
  • Java Transformation
  • Update Strategy Transformation

Module 4: Module 4: Advanced Concepts & Development Techniques

  • Implementing Constraint-Based Load Ordering
  • Implementing Target Load Plan
  • Debugging Mapping (Before and After Session Creation)
  • Data Extraction from Flat Files (Fixed Width and Delimited)
  • Creating and Implementing Unconnected Lookup
  • Creating and Implementing Unconnected Stored Procedure
  • Creating and Implementing Reusable Transformation
  • Creating and Implementing Mapplet
  • SQL Override (Source Qualifier as Filter and as Joiner)
  • Defining and Using Mapping Parameter
  • Defining and Using Mapping Variable
  • Data Extraction from Indirect Files (File Repository)
  • Slowly Changing Dimensions (SCD) - Type 1, Type 2, Type 3
  • Reusable and Non-reusable Sessions
  • Creating and Implementing Worklet
  • Scheduling Workflow
  • Executing Workflow Using pmcmd Command
  • Exporting and Importing Mappings
  • Creating and Using Public and Private User-Defined Function (UDF)
  • Creating and Using E-mail Task
  • Creating and Implementing Dynamic Lookup
  • Implementing Change Data Capture (CDC)
  • Implementing Pre-SQL and Post-SQL
  • Creating and Implementing Command Task
  • Creating and Implementing Event Wait and Event Raise Task
  • Creating and Implementing Timer Task
  • Creating and Implementing Assignment Task
  • Creating and Implementing Control Task
  • Creating and Implementing Decision Task
  • Performance Tuning
  • Push-down Optimization
  • UNIT Testing (Database Level and Mapping Level)
  • Normal and Bulk Loading
  • Link Conditions

Module 5: Module 5: Practical Implementation of Real Scenarios

  • Everyday Real-Time Scenarios Practice for Ten Days
  • Every Student Must Complete Practical Real-Time Scenarios (Mandatory Requirement)
  • Review of Frequently Asked Interview Questions (SQL and Informatica)
  • Explanation of the Project

About the Instructor

G

G. Sampath Goud

Industry Expert

Informatica PowerCenter
$316$232-36% OFF

Approx. price, billed in INR (₹). Final amount confirmed at enrollment.

Full lifetime access

Certificate of completion

Access on mobile and desktop

Job assistance included

Informatica PowerCenter | SkyTrainings