Do we need an ETL tool? When do we go for the tools in the market?

  • Interview Candidate
  • 2
  • 4908

Showing Answers 1 - 2 of 2 Answers

Praveen

  • Aug 14th, 2005
 

ETL Tools are meant to extract, transform and load the data into Data Warehouse for decision making. Before the evolution of ETL Tools, the above mentioned ETL process was done manually by using SQL code created by programmers. This task was tedious and cumbersome in many cases since it involved many resources, complex coding and more work hours. On top of it, maintaining the code placed a great challenge among the programmers. 
 
These difficulties are eliminated by ETL Tools since they are very powerful and they offer many advantages in all stages of ETL process starting from extraction, data cleansing, data profiling, transformation, debuggging and loading into data warehouse when compared to the old method.

sithusithu

  • Jan 9th, 2006
 

  1. Normally ETL Tool stands for Extraction Transformation Loader

 

  1. This helps you to extract the data from different ODS/Database,

 

  1. If you have a requirement like this you need to get the ETL tools, else you no need any ETL

Cheers,

Sithu

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions