Informatica Training Online

Informatica Online Training

Data Warehouse Concepts

• Introduction to the 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
• 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
• 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, Teradata)
• 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 transformation
• 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
• WorkLets
• Worklets 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
• Busines Analyst, System Analyst
• System Architect
• Technical Architect, ETL Lead
• Stakeholders, Busines users
• Effective ways of using Data warehouse