Informatica is a company that offers the following tools

  • Informatica Powercenter
  • Informatica PowerExchange
  • Informatica Reporting Services

Informatica Powercenter

Informatica Powercenter is an ETL tool which is responsible to convert source ER modeling data into dimensional modeling data. Informatica has complete End to End solutions in ETL side which satisfies all business needs in less cost.

Informatica PowerExchange

Informatica PowerExchange is another tool from Informatica company to migrate the data from source database to Target database. Informatica PowerExchange is used for data migrations.

Informatica Reporting Services

Informatica Reporting Services is a Reporting tool from Informatica company. Informatica Reporting Services is used for generating business reports from various databases.

In Informatica Powercenter We have Server software and client software. Server software is responsible for execution. Informatica Powercenter client software has the following components

Informatica Designer

Informatica Workflow Manager

Informatica Workflow Monitor

Informatica Repository Manager

As we know that Informatica Powercenter is an ETL Tool, now we need to know what is ETL  stands for ? ETL stands for Extract Transforms and Load. Informatica is used to read data from various sources which includes many Relational databases like Oracle, DB2, Sybase, MySQL, SQL Server Exadata, Greenplum, vertica, Neoview, PostgreSQL, Netezza , VSAM, Web Services and Teradata. Informatica Powercenter can also supports to read XML files, flat files. Informatica supports most operating systems and platforms line Windows, Linux, Solaris, HP-UX, AIX, Tru64.

Informatica supports to read data from various relational databases, After reading data from source we will transform that data based on our requirement and then load that data into data warehouse. This process of extracting, transforming and loading is called data acquisition. Informatica Powercenter is used to maintain current data and historical data but in ordinary databases we can only maintain current data.  In Informatica we will do most of the work by simply dragging and dropping with mouse in the Informatica designer. This makes it very easy to understand the users what is going on. Informatica can also be used as a Integration tool.