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