Informatica Training

Informatiica Training

Informatica is the best ETL tool in the market. It is capable of extracting data from multiple heterogeneous sources, transforming them as per business requirement and loading to target tables. Its used in Data migration and loading projects.

Course Information

Informatica Course Duration: 40 Hours

Informatica Training Timings: Week days 1-2 Hours per day (or) Weekends: 2-3 Hours per day

Informatica Training Method: Online/Classroom Training

Informatica Study Material: Soft Copy

Course Content

Data warehouse basics

OLTP System

Datawarehouse

Different Defeinitions of datawarehouse

Difference between OPERATIONAL DS AND DWH

Types of ETL

Data Extraction

DataTransformation

Data Merging

Data Loading

Types of Data loading

Data Aggregation

Datawarehouse Approaches

Top down approach and Bottom up approach

DW Life cycle

DW-database design

Star schema and Snow flake schema

Dimensional modelling

Facts and dimensions

Granuality

Types of Dimensions

Types of fact table

Types of Olap

Informatica Power Center 9.1 

Power center Administration

Informatica Power center architecture

Power center components

ETL Plan

Power center Clients

Desiginer

Workflow manager

Work Flow monitor

Workflow manager

Repository manager

Power center repository

Administrative tool

Repository services

Integration services

Power center domain

Application services

Concept of nodes and grid

Service manager

Power center administration console

Repository Administration

Creating Repository Users and Groups .

Connecting to the Repository.

Creating a Group

Assigning Privileges to a Group.

Creating a User

Creating a Folder

Folder Permissions

Creating Folders

Using the designer

Creating Source Tables.

Creating Target Definitions.

Creating Target Tables

Creating a Pass-Through Mapping

Creating source definitions

Creating a Mapping

Connecting Transformations

Transformation Creation

Using Transformations

Creating a Mapping with Aggregate Values

Active and passive transformations

Creating an Aggregator Transformation

Creating an Expression Transformation

Creating a Lookup Transformation

Connecting the Target

Creating the Session

Creating the Workflow

Creating a Mapping with SCD Type 1 and SCD Type 2

Creating a Filter Transformation

Creating a Sequence Generator Transformation

Creating a Stored Procedure Transformation

Completing the Mapping

Creating the Target

Creating a Mapping with

Creating an Expression Transformation

Creating Router Transformations

Completing the Mapping

How to monitor loads 

Use of Workflow monitor

Using the workflow manager

Connecting Transformations

Creating Sessions and Workflows

Configuring Database Connections in the Workflow Manager

Creating a Reusable Session

Creating a Workflow

Running and Monitoring Workflows

Opening the Workflow Monitor

Workflow  Tasks

Session

Assignment task

Link task

Event raise task

Event wait task

Timer task

Post session and Pre-session commands

Session recovery

Commit points

Creation of Parameter file

Mapping and session parameter

Performance tuning in ETL

Various optimization technique

Pushdown optimization

Incremental  aggregation

Practicals 

Key Features

Instructor Led Informatica Online Training

Flexible Time At Your Convenience

Over 1,00,000+ Professionals Trained Across 100 Countries

24x7 Live Support via Chat, Mail and Phone

Corporate Training and On-Job Support

Request for demo