iinformtca  

 INFORMATICA ONLINE TRAINING COURSE

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

Mappings

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

Lab 4 –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.

Lab 6 – Start and Monitor a Workflow

Debugger

  • 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

Advantage

Functionality

Lab 15 – Straight Load
Lab 16 – Conditional Lookups

 

Heterogeneous Targets

  • Heterogeneous target types
  • Target type conversions and limitations

Lab 17 – Heterogeneous Targets

Mapplets

  • 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

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