Informatica Course Curriculum

Informatica Course Curriculum

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

• Software Installation

• Informatica 9 Server/Client Installation on Windows

  Power Center Architecture and Components

• Introduction to informatica Power Center

• Difference Between Power Center and Power Mart

• Power Center 9 architecture

• Power Center 7 architecture vs Power Center 8 and 9 architecture

• Extraction, Transformation and loading process

• Power Center tools: Designer, Workflow manager, Workflow Monitor, Repository Manager, Informatica Adminstration Console.

• Repository Server

• Repository maintenance

• Repository Server Administration Console

• Security, Repository, privileges and folder permissions

• Metadata extensions

  Power Center Developer Topics

• Create a Folder

• How to provide Previllages

• Source Object Definitions

  Source types

• Relational Tables (Oracle, Tera data)

• Flat Files (fixe width, Delimiter Files)

• Xml Files

  Source properties

  Analyze Source Data, Import Source

 Target Object Definitions

• Target types

• Target properties

  Import Targets

• Transformation Concepts

• Transformation types and views

• Transformation features and ports

• Informatica functions and data types

  Mappings

• Mapping components

• Source Qualifier transformation

• Pre SQL and Post SQL

• Mapping validation

• Data flow rules

  Create a Mapping, session, and workflow

• Workflows

• 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.

  Start and Monitor a Workflow

• Debugger

• Debugger features

• Debugger windows

• Tips for using the Debugger

  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

  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

   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

   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

  Basic and Advance Lookup Target options

• Row type indicators

• Row loading operations

• Constraint- based loading

• Rejected row handling options

   Deleting Rows

• Update strategy expressions

• Data Driven Inserts and Rejects

• Router transformation

• Using a router

• Router groups

  Router Conditional Lookups

• Usage and techniques

• Advantage

• Functionality

  Straight Load

  Conditional Lookups

• Heterogeneous Targets

• Heterogeneous target types

• Target type conversions and limitations

   Heterogeneous Targets Mapplets

• Functionality and Advantages

• Mapplet types and structure

• Mapplet limitations

    Mapplets

• Reusable transformations

• Advantages

• Limitations

• Promoting and copying transformations

   Reusable transformations /Sequence Generator transformation

• Using a sequence Generator

• Sequence Generator properties

• Dynamic Lookup

• Dynamic lookup theory

• Usage and functionality

• Advantages

  Dynamic Lookup Concurrent and sequential Workflows

• Concurrent Workflows

• Sequential Workflows

• Stopping, Starting and suspending tasks and workflows

  Sequential Workflow Additional Transformations

• Union Transformation

• Rank transformation

• Normalizer transformation

• Custom Transformation

• Transformation Control transformation

• XML Transformation

• SQL Transformation

• Stored Procedure Transformation

• External procedure Transformation

• SQL Transformation

  Lab Sessions- For above transformations Error Handling

• Overview of Error Handling Topics

• Review various BI Reporting methods

• Informatica - Best practices

• Mapping Design through Visio tool

• Data Loading techniques for huge volume of data

• XML Data Loading – Best Practices

• Incremental Loading and Rollback procedures

• Slowly changing dimension – Overview

• Caching VS Direct load

• Transaction Handling

• Performance Tuning

• Traceability and Event Logging

  Error handling fatal and non Fatal Workflow Tasks

• Command

• Email

• Decision

• Timer

• Control

• Even Raise and Wait

• Sequential Batch Processing

• Parallel 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 Mapping Variables and Parameters
 
   Creating Mapping Variables and Updating Variables
 
   Creating Parameter File and associating file to a Session
 
   System Variables
 
  Variables functions
 
  Override Mapping Variable with Parameter Files
 
   Dynamically Updating a Source Qualifier with Mapping Variable

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

• Incremental Loading

  SCD 1, 2, 3

• Reusable Workflow Tasks

• Work Lets

• Work lets Limitation

• Sessions

• Reusable Sessions

  Create Worklets using Tasks Command Line Interface ( PMCMD)

• Overview of PMCMD and functions

• Overview of PMREP and functions

  PMCMD

• PMREP

• Informatica Migrations:

• Copying Objects

• Objects export and import (XML)

• Deployment groups

  Workflows Scheduling

• Using Informatica

• Unix crontab, third party tools

  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 prouction 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