Flat 20% & upto 50% off + Free additional Courses. Hurry up!

Introduction of Informatica


In 1993 a software company Informatica was founded which provide data integration solutions. A lot of times when people say Informatica they actually mean Informatica PowerCenter.

In short, It is world’s most important ETL tool which quickly grip over the market as an Enterprise Integration Platform.

It provides applications for the following Data Integration areas:

  • Data Migration – ERP and legacy systems consolidation, new application implementation
  • Data Synchronization – business-to-business data transfer
  • Data Warehousing
  • Data Hubs, Data Marts
  • Master Data Management (MDM)
  • Business Intelligence Reporting
  • Business Activity Monitoring (BAM)

Get the Informatica online training for mastering data integration.

Informatica Concepts

Data warehousing

A data warehousing is a process of building a data warehouse. A process includes.

  • Business requirement analysis
  • database design
  • ETL development and testing
  • Report development and testing

Read these Top Trending Informatica interview Q’s that helps you grab high-paying jobs !

Data Acquisition

It is a process of extracting the relevant business information. Transforming data into a required business format and loading into the target system.

A data acquisition is defined with following type of process

  • data extraction
  • data transformation
  • data loading

Interested in learning Informatica course details for making an informed choice?

Data Extraction

It is a process of reading the data from various types of source systems. The following are type of sources which are used to define extraction.

  • ERP Source
  • SAP
  • Oracle applications
  • JD Edwards
  • people soft
  • File Sources
  • XML Files
  • Flat files
  • Relational Sources
  • Oracle
  • SQL Server
  • DB2
  • Sys bases
  • Legacy Sources
  • Main frames
  • AS 400
  • Cabal files etc

Data transformation

The process of transformation data and cleansing the data into the required business format.

The following are data transformation activities takes place in the stage (temporary memory).

  • Data merging
  • Data cleansing
  • Data scrubbing
  • Data aggregation
Data Merging

The process of integrating the data from multiple sources system is known as Data Merging.

There are two types of data merging method which takes places in the staging

  • Horizontal merging – Horizontal Merging is the process of merging the records horizontally.
  • vertical merging – When two sources have same “meta data” then the process of merging the records is known as Vertical Merging.

Looking for top jobs in Business Intelligence ? This blog post gives you all the information you need!

Data Cleansing

It is a process of changing inconsistencies and inaccuracy data. And also we can say that it is the process of removal of unwanted data from staging.

Data Scrubbing

It is a process of deriving new attributes & Attributes is a table column.

Data Aggregation

The process of calculating the summary from detailed data.

Data Loading

The procedure of adding the data into a target system is called Data Loading.

There are two types of Data Loading-

  • Initial load (or) delta load
  • Incremental load (or) delta load

Initial Load on full load

We are extracting data from source system to load the data into target system first time the records are entered directly to the target system.

Delta or Incremental load

We are extracting data from the source system to load the data into destination system first time newly entered the records as well as update the records into the target system.


OLAP is a set of specification or technology which recovers the data from data warehouse and it is interface or get way between the user and database.


Types of OLAPS

DOLAP (Desktop OLAP):- DOLAP is used to query data from database that build by utilizing desktop databases.

ROLAP (Relation OLAP):- ROLAP is used to Query data from relational sources.

MOLAP (MULTIOLAP):-It is used to Query the data from multi dimensional sources.

HOLAP (hybrid HOLAP):-It is a combination ROLAP and MOLAP.

Learn more about Informatica in this insightful blog now!

"0 Responses on Introduction of Informatica"

Leave a Message

100% Secure Payments. All major credit & debit cards accepted Or Pay by Paypal.

Sales Offer

  • To avail this offer, enroll before 28th February 2017.
  • This offer cannot be combined with any other offer.
  • This offer is valid on selected courses only.
  • Please use coupon codes mentioned below to avail the offer

Sign Up or Login to view the Free Introduction of Informatica.