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
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.
Basic Data Warehousing Concepts
OLAP VS OLTP
Data Warehouse Architecture (Basic)
Data Warehouse Architecture (with a staging area)
Slowly changing Dimension (Type 1,2 and 3)
Power Center Components
Informatica Concepts and Overview
Working with relational sources
Working with Flat files
Working with relational targets
Working with flat file targets
Source Qualifier Transformation
Sequence Generator Transformation
Transaction control Transformation
Stored Procedure Transformation
Update Strategy Transformation
Power Center Transformation Language
User Defined Functions
Advanced Informatica concepts
Unconnected Lookup Transformation
Mapplet and Types of Mapplets
Defining Reusable Transformation
Tasks and Types of Tasks
Constraint Based Load Ordering
Target Load Plan
Types of Batch Processing
Defining Session Parameters
Difference between Normal and Bulk Loading
Types of Lookup Caches
Static Lookup Caches
Dynamic Lookup Caches
Persistence lookup Cache
Shared lookup Cache
Sorter and Rank Cache