Duration: 4 –  5 Weeks

Data Warehouse Concepts:

  • Introduction to Data warehouse
  • What is Data warehouse and why we need Data warehouse
  • OLTP vs ODS vs Data warehouse
  • Dimensional modeling
  • Star schema/Snowflake schema/Galaxy schema
  • Dimensions / Facts tables.
  • Slowly Changing Dimensions and its types.
  • Data Staging Area
  • Different types of Dimensions and Facts.
  • Data Mart vs Data warehouse
  • DWH Approaches: Ralph Kimball’s vs Bill Inmon’s

Informatica Power Center 9:

Software Installation:

Informatica 9 Server/Client Installation on Windows/Unix.

Power Center Architecture and Components:

  • Introduction to Informatica Power Center
  • Difference Between Power Center and Power Mart
  • PowerCenter 9 architecture
  • PowerCenter 7 architecture vs PowerCenter 8 and 9 architecture
  • Extraction, Transformation and loading process 

Power Center tools: Designer, Workflow manager, Workflow Monitor,

Repository Manager, Informatica Adminstration Console.

  • Repository Server and agent
  • Repository maintenance
  • Repository Server Administration Console
  • Security, Repository, privileges and folder permissions
  • Metadata extensions

Power Center Developer Topics:

Lab 1- Create a Folder.

  • How to provide Previllages
  • Source Object Definitions

        Source types

–       Relational Tables (Oracle, Teradata)
–       Flat Files (fixe width, Delimiter Files)
–       Xml Files
–       COBOL Files
–       Sales Force

Source properties

Lab 2- Analyze Source Data, Import Source.

  • Target Object Definitions

–       Target types
–       Target properties

Lab 3- Import Targets

  • Transformation Concepts
  • Transformation types and views
  • Transformation features and ports
  • Informatica functions and data types


  • Mapping components
  • Source Qualifier transformation
  • Pre SQL and Post SQL
  • Mapping validation
  • Data flow rules

Lab 4 –Create a Mapping, session, and workflow


  • Workflow Tools
  • Workflow Structure and configuration
  • Workflow Tasks
  • Workflow Design and properties

Session Tasks

  • Session Task properties
  • Session components
  • Transformation overrides
  • Session partitions

Workflow Monitoring

  • Workflow Monitor views
  • Monitoring a Server
  • Actions initiated from the workflow Monitor
  • Gantt chart View and Task view.

Lab 6 – Start and Monitor a Workflow


  • Debugger features
  • Debugger windows
  • Tips for using the Debugger

Lab 7 –The Debugger

Expression transformation

  • Expression, variable ports, storing previous record values.

Different type of Ports

  • Input/ output / Variable ports and Port Evaluation
  • Filter transformation
  • Filter properties

Lab 8- Expression and Filter

Aggregator transformation

  • Aggregation function and expressions
  • Aggregator properties
  • Using sorted data
  • Incremental Aggregation

Joiner transformation

  • Joiner types
  • Joiner conditions and properties
  • Joiner usage and Nested joins

Lab 9 – Aggregator, Heterogeneous join

  • Working with Flat files
  • Importing and editing flat file sources & Targets

Lab Session – Use Flat file as source.

Sorter transformation

  • Sorter properties
  • Sorter limitations

Lab 10 – Sorter

  • Propagate Attributes.
  • Shared Folder and Working with shortcuts.
  • Informatica built in functions.

Lookup transformation

  • Lookup principles
  • Lookup properties
  • Lookup techniques
  • Connected and unconnected lookups.
  • Lookup Caches

Lab 11 – Basic and Advance Lookup

 Target options

  • Row type indicators
  • Row loading operations
  • Constraint- based loading
  • Rejected row handling options

Lab 12 – Deleting Rows

  • Update Strategy transformation
  • Update strategy expressions

Lab 13 – Data Driven Inserts and Rejects


  • Router transformation

Using a router

Router groups

Lab 14 – Router

  • Conditional Lookups

Usage and techniques



Lab 15 – Straight Load
Lab 16 – Conditional Lookups


Heterogeneous Targets

  • Heterogeneous target types
  • Target type conversions and limitations

Lab 17 – Heterogeneous Targets


  • Functionality and Advantages
  • Mapplet types and structure
  • Mapplet limitations

Lab 18 – Mapplets

  • Reusable transformations
  • Advantages
  • Limitations
  • Promoting and copying transformations

Lab 19 – Reusable transformations

  • Sequence Generator transformation
  • Using a sequence Generator

Sequence Generator properties

  • Dynamic Lookup
  • Dynamic lookup theory
  • Usage and functionality
  • Advantages

Lab 20 – Dynamic Lookup

  • Concurrent and sequential Workflows
    • Concurrent Workflows
    • Sequential Workflows
  • Stopping, Starting and suspending tasks and workflows

Lab 21 – Sequential Workflow

  • Additional Transformations
    • Union Transformation
    • Rank transformation
    • Normalizer transformation
    • Custom Transformation
    • Transformation Control transformation
    • XML Transformation
    • SQL Trasnformation
    • Stored Procedure Transformation
    • External procedure Transformation
    • SQL Transformation
  • Lab Sessions- For above transformations
  • Error Handling
  • Overview of Error Handling Topics

Lab 22 – Error handling fatal and non Fatal

  • Workflow Tasks:
    • Command
    • Email
    • Decision
    • Timer
    • Control
    • Even Raise and Wait
    • Sequential Batch Processing

Parllel Batch Processing

  • Lab Sessions – With Workflow tasks
  • Link Conditions
  • Team Based Development

Version Control

Checking out and checking in objects.

  • Performance Tuning
  • Overview of System Environment
  • Identifying Bottlenecks.

Optimizing Source, Target, mapping, Transformation, session.

  • Mapping Parameters and Variables

Introduction to Mappng Variables and Parameters

  • Creating Mapping Variables and Updating Variables
  • Creating Parameter File and associating file to a Session
  • System Variables
  • Variables functions

Lab 26 – Override Mapping Variable with Parameter Files
Lab 27 – Dynamically Updating a Source Qualifier with Mapping Variable

  • Slowly Changing Dimensions Type 1, Type 2, Type 3
  • Incremental Loading

Lab 28– SCD 1, 2, 3

  • Reusable Workflow Tasks
  • WorkLets
  • Worklets Limitation
  • Sessions
  • Reusable Sessions

Lab 29 – Create Worklets using Tasks

  • Command Line Interface ( PMCMD)
  • Overview of PMCMD and functions.
  • Overview of PMREP and functions.

Lab 30 : PMCMD

  • Informatica Migrations:

Copying Objects

  • Objects export and import (XML)
  • Deployment groups
  • Workflows Scheduling:
  • Using Informatica
  • Unix crontab, third party tools.

Lab 30: Informatica Project- Case Study

  • Sales Data mart.
  • Loading Dimensions and Facts.
  • ETL Best Practices and methodologies
  • Review the Industry best practices in ETL Development
  • Review Real time project experiences of trainer
  • Discuss what is learned techniques are useful in real world
  • How to design effective ETL process
  • Important considerations in designing ETL process
  • Discuss real world production issues and support
  • Discuss various roles in ETL world
  • Business Analyst, System Analyst
  • System Architect
  • Technical Architect, ETL Lead
  • Stakeholders, Business users
  • Effective ways of using Data warehouse
  • Review various BI Reporting methods
    • Q/A-Interview preparation/Placements
    • Answer students questions
    • Tips for interview preparation
    • How we can assist in placement and future growth
    • Discuss other related technologies like Business Intelligence (BI)
    • Advancing career options
Call Us : (718) 313-0499 / (718) 313-0593
Email Us :


Leave your details and Our training consultant will get back to you
LiveZilla Live Help

Course Features:

  • +  Online Classes: 30 Hrs
  • There will be 10 instructor led Interactive online classes during the course. Each class will be of approximately 3 hours and will happen at the scheduled time of the batch you choose. You have the flexibility to reschedule your class in a different batch if you miss any class. Class recordings will be uploaded in the LMS after the class. The access to class recordings is for lifetime.

  • +  Assignments: 40 Hrs
  • Each class will be followed by practical assignments which can be completed before the next class. We will help you setup a VM on your system to do the practicals. We shall also provide you remote access to our Hadoop Cluster on AWS. Our 24x7 expert support team will be available to help through email, phone or Live Support for any issues you may face during the Lab Hours.

  • +  Project: 20 Hrs
  • Towards the end of the course, you will be working on a project where you be expected to perform Big Data Analytics using Map Reduce, Pig, Hive & HBase. You will get practical exposure about Data Loading techniques in Hadoop using Flume and SQOOP. You will understand how Oozie is used to schedule and manage Hadoop Jobs. You will also understand how the Hadoop Project environment is setup and how the Test environment is setup.

  • +  Lifetime Access
  • You get lifetime access to the Learning Management System (LMS). The Class recordings and presentations can be viewed online from the LMS. The installation guides, sample codes and project documents are available in downloadable format in the LMS. Also, your login will never get expired.

  • +  24 x 7 Support
  • We have 24x7 online support team available to help you with any technical queries you may have during the course. All the queries are tracked as tickets and you get a guaranteed response from a support engineer. If required, the support team can also provide you live support by accessing your machine remotely. This ensures that all your doubts and problems faced during labs and project work are clarified round the clock.

  • +  Get Certified
  • We have 24x7 online support team available to help you with any technical queries you may have during the course. All the queries are tracked as tickets and you get a guaranteed response from a support engineer. If required, the support team can also provide you live support by accessing your machine remotely. This ensures that all your doubts and problems faced during labs and project work are clarified round the clock.