Informatica

Course Overview:

Informatica Training provides a strong foundation on all the core concepts of Informatica Powercenter to create, execute, administer, and schedule ETL processes and understand how these are used in data warehouse and data mining operations. It covers topics starting from basics to advanced level to help attendees acquire vast knowledge of Informatica products, architecture, designer, Workflow Manager, transformations, mappings, and more.

Course Content:

Introduction

♦ Overview in this module.

♦ Overview with Basic Definitions

♦ Informatica Products

♦ Informatica Architecture

♦ Tools and their roles

♦ Folders -sub Folders

♦ Power Centre I Power Malt

Informatic Designer

♦ Introduction to designer

♦ Designer interfaces

♦ Designer tools

♦ Defining Sources

(i) Database as a source

(ii) Rat Flies sources

♦ Defining Targets

♦ Importing from database

♦ Creating a new target

♦ Creating target database object

Informatica Designer – Advance

♦ Mapping Introduction

♦ Source Qualifier

♦ Ports

♦ Mapping -Table to Table

♦ Mapping flat File to Table

♦ Connected/Unconnected Transformations

♦ Active and Passive Transformation

♦ Source Qualifier Transformation

♦ SQl Override-Source Qualifier Transformation

♦ Mapping Source Qualifier as Filter

♦ Source qualifier to join Data

♦ Filter Transformation

♦ Expression Transformation

♦ Sequence Generator Transformation

♦ Rank Transformation

♦ Router Transformation

♦ Aggregator Transformation

♦ Joiner Transformation

♦ Stored procedure Transformation (Connected & Unconnected)

♦ Union Transformation

♦ XMl Transformation

♦ Mapping Wizards

♦ Implementing Type-I, Type-II, Type-III and Mappings

Informatica – Workflow Manager

♦ Workflow Introduction

♦ Tasks

♦ Workflow tools

♦ Connections

Working with Tasks

♦ Command Task

♦ Email Task

♦ Session Task

♦ Link Conditions

♦ Event Wait & Event Raise

♦ Setting Properties of Session Task

♦ Creating Workflow

♦ Starting Workflow

♦ Monitoring Workflo

We can assure a 100% job guarantee and Placement. Contact us for Free - Demo