Before diving into Informatica lets do some formalities and talk about ETL and why to
use Informatica. We are not going to talk about data warehousing and its fundamentals here as Mr. Google is always there for you. But if you still have any questions on data warehousing you can always ask here.
ETL is an abbreviation of the three words Extract, Transform and Load. It is an ETL process to extract data, mostly from different types of system, transform it into a structure that's more appropriate for reporting and analysis and finally load it into the database.
There are lot of ETL tools in market some paid some open-source. a few to name :
use Informatica. We are not going to talk about data warehousing and its fundamentals here as Mr. Google is always there for you. But if you still have any questions on data warehousing you can always ask here.
ETL is an abbreviation of the three words Extract, Transform and Load. It is an ETL process to extract data, mostly from different types of system, transform it into a structure that's more appropriate for reporting and analysis and finally load it into the database.
There are lot of ETL tools in market some paid some open-source. a few to name :
- Comercial ETL Tools:
- IBM Infosphere DataStage
- Informatica PowerCenter
- Oracle Warehouse Builder (OWB)
- Oracle Data Integrator (ODI)
- SAS ETL Studio
- Business Objects Data Integrator(BODI)
- Microsoft SQL Server Integration Services(SSIS)
- Ab Initio
- Freeware, open source ETL tools:
- Pentaho Data Integration (Kettle)
- Talend Integrator Suite
- CloverETL
- Jasper ETL
