Informatica Training

Informatica  Training in Chennai

Dhaksha Technology One of the best informatica training in chennai. We provide world class Informatica certification and placement training in Informatica Basics, Informatica Interview Questions, transformations. Study Material, Certification and Interview Guidance are provided during the course. All our training sessions are Completely Real time.

What is Informatica?

Informatica is a Software development company, which offers data integration products. If offers products for ETL, data masking, data Quality, data replica, data virtualization, master data management, etc.

Informatica Powercenter ETL/Data Integration tool is a most widely used tool and in the common term when we say Informatica, it refers to the Informatica PowerCenter tool for ETL.

Informatica Powercenter is used for Data integration. It offers the capability to connect & fetch data from different heterogeneous source and processing of data.

For example, you can connect to an SQL Server Database and Oracle Database both and can integrate the data into a third system.

The latest version of Informatica PowerCenter available is 9.6.0. The different editions for the PowerCenter are

Why do we need Informatica?

Informatica comes to the picture wherever we have a data system available and at the backend we want to perform certain operations on the data. It can be like cleaning up of data, modifying the data, etc. based on certain set of rules or simply loading of bulk data from one system to another.

Informatica offers a rich set of features like operations at row level on data, integration of data from multiple structured, semi-structured or unstructured systems, scheduling of data operation. It also has the feature of metadata, so the information about the process and data operations are also preserved.

informatica training in chennai
Informatica Course Content

Basic Data Warehousing Concepts

Data Warehouse
Data Mart
OLAP VS OLTP
Data Warehouse Architecture (Basic)
Data Warehouse Architecture (with a staging area)
Dimensional modeling
Star Schema
Snowflake Schema
Dimensional table
Fact table
Slowly changing Dimension (Type 1,2 and 3)

Power Center Components

Designer
Repository Manager
Workflow Manager
Workflow Monitor

Informatica Concepts and Overview

Informatica Architecture
Source Qualifier
Target Designer
Transofrmations
Mappings
Mapplets
Sessions
Tasks

Sources

Working with relational sources
Working with Flat files

Targets

Working with relational targets
Working with flat file targets

Transformations

Source Qualifier Transformation
Filter Transformation
Joiner Transformation
Sorter Transformation
Union Transformation
Expression Transformation
Sequence Generator Transformation
Router Transformation
Aggregator Transformation
Rank Transformation
Lookup Transformation
Transaction control Transformation
Normalizer Transformation
Stored Procedure Transformation
Update Strategy Transformation

Power Center Transformation Language

Numeric function
String function
Date function
Conversion function
Aggregate function
Cleansing function
User Defined Functions

Advanced Informatica concepts

Unconnected Lookup Transformation
Mapplet and Types of Mapplets
Defining Reusable Transformation
Tasks and Types of Tasks
Scheduling Workflow
Constraint Based Load Ordering
Target Load Plan
Types of Batch Processing
Link Conditions
Mapping Parameters
Mapping Variables
Defining Session Parameters
Session Recovery
Difference between Normal and Bulk Loading
PMCMD Utility
PMREP Utility
Incremental Aggregation
Types of Lookup Caches
Static Lookup Caches
Dynamic Lookup Caches
Persistence lookup Cache
Shared lookup Cache
Sorter and Rank Cache

Task Types

Session
Command
EMAIL
Timer
Event Wait
Event Raise
Decision
Assignment
Control
Worklet