gopisoft IT solutions and marketing firm
Home | Google/Facebook Advertising | Malware Removal | Data Solutions | Mobile Applications

Informatica PowerCenter Development

We have conducted Informatica trainings at some of the world's biggest IT firms like Wipro . This five days Informatica PowerCenter Development training will help participants in getting familiar with Informatica PowerCenter and will be able to develop PowerCenter code. Our trainer has worked for clients like GE , Wellpoint USA etc. and have successfully implemented Informatica projects at some of the biggest firms across the globe. Please check day wise breakup of five days course on Informatica PowerCenter Development below.
Day 1

Introduction

Introduction
PowerCenter Nodes
PowerCenter Domain
PowerCenter Repository

PowerCenter Architecture
Server architecture
Repository Service
Integration Service

Installing Informatica 9
Install and Configure Oracle database
Repository Schema creation
Create infa_repo user for repository
Install and configure Oracle client
Setup TNS entries for the server
Informatica installation on windows platform
Environment variables setup
Network host file setup

PowerCenter Client
Install Client Applications
Repository manager
Designer
Workflow manager
Workflow monitor
Configure Domain in Client applications
Connect User

Configuring PowerCenter 9.x Services
Administration Console
Domain Configuration
Integration service creation
Repository creation
Repository Modes
Metadata tables
Repository backup management
Version control
Server variables assignment

Day 2

Using the Designer
Overview
Configuring Designer Options

Working with Sources
Overview
Working with Relational Sources
Working with files

Working with Targets
Overview
Importing a Target Definition
Manually Creating a Target Definition

Source Qualifier Transformation
Overview
Source Qualifier Transformation Properties
Default Query
Joining Source Data
Adding an SQL Query
Entering a User-Defined Join
Entering a Source Filter
Creating a Source Qualifier Transformation

Workflow Manager
Overview
Workflow Manager Options
Navigating the Workspace

Tasks
Overview
Creating a Task
Configuring Tasks
Working with the Command Task
Working with the Event Task

Sessions
Overview
Creating a Session Task
Editing a Session

Workflows and Worklets
Overview
Creating a Workflow
Working with Worklets
Working with Links

Lab Exercise

Day 3

Working with Transformations
Overview
Creating a Transformation

Expression Transformation
Overview
Expression Transformation Components
Configuring Ports
Creating an Expression Transformation

Filter Transformation
Overview
Filter Transformation Components
Filter Condition
Steps to Create a Filter Transformation

Joiner Transformation
Overview
Joiner Transformation Properties
Defining a Join Condition
Defining the Join Type
Joining Data from a Single Source
Creating a Joiner Transformation

Lookup Transformation
Overview
Lookup Source Types
Connected and Unconnected Lookups
Lookup Components
Lookup Properties
Lookup Query
Lookup Condition
Lookup Caches
Unconnected Lookup Transformations
Creating a Lookup Transformation

Lab Exercise

Day 4

Router Transformation
Overview
Working with Groups
Creating a Router Transformation

Sequence Generator Transformation
Overview
Common Uses
Sequence Generator Ports
Transformation Properties
Creating a Sequence Generator Transformation

Sorter Transformation
Overview
Sorting Data
Sorter Transformation Properties
Creating a Sorter Transformation

Update Strategy Transformation
Overview
Flagging Rows Within a Mapping
Setting the Update Strategy for a Session

Aggregator Transformation
Overview
Components of the Aggregator Transformation
Aggregate Expressions
Group By Ports
Using Sorted Input
Creating an Aggregator Transformation

Union Transformation
Overview
Properties
Creating Union transformation

Lab Exercise

Day 5

Mapplets
Overview
Understanding Mapplet Input and Output
Using the Mapplet Designer
Using Mapplets in Mappings

Mapping Parameters and Variables
Overview
Mapping Parameters
Mapping Variables

Command Line Programs
Password encryption
PMCMD utility
PMREP
Infaservice

Performance Tuning and Best Practices
Identifying bottlenecks
Tuning Source components
Tuning Target components
Tuning transformations
Partitioning
Bulk mode
Commit interval
Line sequential buffer

Team Based development
Overview
Check in and check out
Version comparison

Lab Exercise

Home | support@gopisoft.com | Copyright Gopisoft Private Limited. All rights reserved