ETL tools in data warehousing?
Posted on | January 8, 2010 | 3 Comments
Once you have decided to build a data warehouse for the company.The challenges lies in deciding which ETL tool to use.There are plenty of ETL tools like Pentaho Data Integration,Abnitio.The most used ETL tool is Informatica.ETL stands for Extract,Transform and Load.Although most of ETL tool can perform all the three function.Generally one or more process of extraction,transformation and load may be performed by some external software.Lets us understand all the three process one by one
Extract – The process involves extraction fo data from homogenoes or heterogenoes sources to load into the data warehouse.
Transform – Once the data is extracted various transformation need to be performed so that the data is useful for various analysis.
Loading – The last step is to load the the data into datawarehouse.
The list of popular ETL tools in the market are
1. Informatica
2. Oracle Warehouse Builder
3. Pentaho
4. Ab Initio
5. Datastage
Comments
3 Responses to “ETL tools in data warehousing?”
Leave a Reply
February 1st, 2010 @ 9:50 am
Thanks for your post on ETL tools.
There are other tools used for ETL, such as Talend Open Studio.
It is an open source data integration software, able to help you if you need an ETL program.
Redben
March 30th, 2010 @ 7:35 am
Hi Techies,
I have Web mining experience and now moving into Data warehouse BU line. I would like to know which tool to master which would be very helpful for the near future. I understand every tool has its own advantages. But if you’ll can suggest any recommended tool which provides good future in terms of the pay package and projects available, I would request my company to train me accordingly. Thanks in advance.
Gokul Sukumar
April 15th, 2010 @ 2:41 am
Hi
I think in ETL informatica is good and reporting BO is one your can learn.