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 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