Informatica Training Chennai

Module 1

Introduction and Architecture

Introduction to Informatica

Architecture of Informatica PowerCenter

Installation and configuration

Informatica Design Process

Domain,node and services

Repository Service

Integration service

Configure security

Informatica Client Tool

Designer,Workflow manager ,Workflow monitor

Designer tools

Source analyzer,target designer,Transformation developer

Mapping and Mapplet designer

Module 2

Mapping Designer

Create a Simple Mapping

Overview of Transformations

Types of Transformations

Active and Passive

Expression Transformation

Source Qualifier Transformation

Introduction to Workflow Manager

Task Developer

Workflow Designer

Creating Connections

Module 3

Flat Files Handling

Create Simple Mappings

Flat File Analysis

Module 4

Architecture Review

Architecture Review

Differences between PowerMart and PowerCenter

Connecting to SAP-FTP Process

Command Task

Create a Mapping

Joiner Transformation

Module 5

Transformations

Create a Mapping

Using Join in a Source Qualifier Transformation

Expression Transformation

Filter Transformation

Module 6

Transformations Session1

Multiple Targets Loading

Router Transformation

Difference Between Filter and Router Transformations

Create a Mapping

Master Outer Join

Module 7

Transformations Session2

Reusable Transformation

Lookup Transformation

Debugger

Handling Multiple Files as Source

Module 8

Mapplets

Sequence Generator Transformation

Multiple Pipelines in a Single Mapping

Target Load Plan-Mapplets

Module 9

Update Strategy

SCD Type 1 mapping Implementation

Update Strategy Transformation

SCD Type 2 and Type 3 mapping Implementation

Module 10

Loading Strategy

Sequential and Parallel Loading

Union Transformation

Dynamic Lookup Cache

Introduction to Fact Loading

Module 11

Transformations

Date Dimension Loading

Lookup Transformation

Persistent Cache

Aggregator Transformation

Sorter Transformation

Creating Stored Procedure

Module 12

Transformations

Normalizer Transformation

Stored Procedure Transformation

Active Vs Passive Transformations

Connected Vs UnConnected Transformations

Module 13

Implementing Incremental Loading

Importance of Mapping Variable

Implementing Incremental Aggregation

Create a Mapping

Incremental Aggregation

Transaction and Variable Port

Transaction Control Transformation

Variable Ports

Module 14

Workflow Tasks

Scheduling

Task Link Properties

Event Raise Task

Event Wait Task

Worklet

Timer

Command

Email

Control

Decision

Assignment

About Informatica

Informatica PowerCenter is a widely used extraction, transformation and loading (ETL) tool used in building enterprise data warehouses. The components within Informatica PowerCenter aid in extracting data from its source, transforming it as per business requirements and loading it into a target data warehouse.Informatica powercenter is produced by Informatica Corp for data warehousing and business intelligence.

In real time, LLC is the world’s number one independent provider of data integration software. Over 5,800 enterprises depend on Informatica to leverage the potential of, and protect , their information from devices (IoT) to mobile to social to big data on-premise, in the cloud and across social networks.

Many of the industries are using ETL tools and in that,the most important one is Informatica.Geoinsyssoft gives you the live session about the informatica through our trainers in chennai. We take extra care for training the students in Informatica for acquiring wide knowledge and getting cleared in basic concepts.For the past decade we were involved in Informatica training in chennai.

We do online,classroom and corporate training.

If you are looking for the best institute for informatica training in chennai, then Geoinsyssoft is your correct choice. Geoinsyssoft’s informatica training in chennai received good reviews from students. We shifted their successful career into data warehousing space.Our Informatica training, will stimulates you to open avenues for carrier success in India and abroad in this space.

Back