Informatica is a company that offers the following tools
- Informatica Power Centre
- Informatica Power Exchange
- Informatica Reporting Services
Informatica Power Centre:
Informatica Power Centre 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 Power Exchange:
Informatica Power Exchange is another
tool from Informatica company to migrate the data from source database
to Target database. Informatica Power Exchange 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 power centre We have
Server software and client software. Server software is responsible for
execution. Informatica power centre client software has the following
components
Informatica Designer
Informatica Workflow Manager
Informatica Workflow Monitor
Informatica Repository Manager.
As we know that Informatica power centre
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 Power Centre 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 Power Centre 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.
