INFORMATICA TRAINING IN PUNE

I GIVE INFORMATICA 9 & 8.6 CORPORATE & ONLINE, CLASSROOM TRAINING.
I TRAINED MANY STUDENTS TILL DATE ON INFORMATICA DIFFERENT VERSIONS.

I have 13 years of experience in INFORMATICA , i worked with different clients (Kaiser permanente,Stanford,Healthalliance,Cephalon,Intel,BASF,lansf
orsakringar,solectron,Nestle,UOB,PetSmart,Quintiles) for data warehouse implementations with INFORMATICA. I can promise you the quality training with 100% support to get job.

Course Objectives

After successfully completing this course, students should be able to:

- Use Informatica Support to resolve questions and problems with PowerCenter 9
- Use PowerCenter 9 Designer to build mappings that extract data from a source to a target, transforming it as necessary
- Use PowerCenter transformations to cleanse, format, join, aggregate and route data to the appropriate targets.
- Perform error handling/trapping using PowerCenter mappings
- Use PowerCenter 9 Workflow Manager to build and run a workflow which executes a sessions associated with a mapping
- Design and build simple mappings and workflows based on essential business needs
- Perform basic troubleshooting using PowerCenter logs and debugger

Informatica Power Center 9:

Software Installation:
Informatica 9 Server/Client Installation on Windows/Unix.
Power Center Architecture and Components:

Introduction to informatica Power Center
PowerCenter 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

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

http://www.facebook.com/home.php#!/pages/A-Gene
sis/104924489599049

Contact 9986009844 (Bangalore)