INFORMATICA

INFORMATICA

Overview:
INFORMATICA is clearly a market leader in the fields of data integration and data quality services. The INFORMATICA Power Center is a powerful tool to integrate, manage and migrate enterprise data Administrators with some experience managing either Power Center or Data Quality Database developers and developer Managers new to INFORMATICA Power Center

Training Objectives of INFORMATICA:
• Database is neutral and hence can communicate with any database
• It is the most powerful data transformations tool and converts one application’s data to another’s format.

Target Students / Prerequisites:
Basic knowledge of SQL.

Course Contents:

Introduction
Overview
Basic Definitions
INFORMATICA products
INFORMATICA Architecture
Tools and their roles
Folders-Sub folders
Power center / Power mart

INFORMATICA Designer – Introduction
Introduction to Designer
Logon to Designer
Designer interfaces
Designer Tools
Defining Sources
Database as a source
Flat File sources
Defining Targets
Importing from database
Creating a new target
Creating target database objects

INFORMATICA Designer
Mapping Introduction
Source Qualifier
Ports
Mapping – Table to Table
Mapping Flat File to Table
Connected /Unconnected Transformations
Active and Passive Transformations
Source Qualifier to join Data
Filter Transformation
Expression Transformation
Sequence Generator Transformation
Rank Transformation
Router Transformation
Aggregator Transformation
Joiner Transformation
Stored Procedure Transformation(Connected and Unconnected)
Union Transformation
XML Transformation
Mapping Wizards
Implementing Type-I, Type-II, Type-III Mappings

INFORMATICA – Workflow Manager
Workflow Introduction
Tasks
Workflow tools
Connections
Defining tasks
Command Tasks
Email Task
Session Task
Link Conditions
Event Wait & Event Raise
Setting Properties of Session Task
Creating Workflow
Starting Workflow
Monitoring Workflow

INFORMATICA Advanced Features
Incremental Aggregation
Map let Implementation
Target Load Plan
Constraint Based Loading
Mapping Variable
Session Parameters
Link Conditions
Reusable Transformation
Task and Types of Tasks
Work let and Types of work lets
Scheduling Workflow
Control flow using Command task and event wait task
Incremental Loading

About the Trainer

10 + Years of IT experience, provided training for over 1000+ professionals online Real-time IT experience which enables to provide dedicated quality training. Teaching is his passion vast experience in providing online training around the globe with good communication skills.