1.

Name some tools that are used in ETL.

Answer»

The use of ETL testing tools increases IT productivity and facilitates the process of extracting insights from big DATA. With the tool, you no LONGER have to use labor-intensive, costly traditional programming METHODS to extract and process data.  

Technology EVOLVED over time, so did solutions. Nowadays, various WAYS can be used for ETL testing depending on the source data and the environment. There are several ETL vendors that focus on ETL exclusively, such as Informatica. Software vendors like IBM, Oracle, and Microsoft provide other tools as well.  Open source ETL tools have also recently emerged that are free to use. The following are some ETL software tools to consider:   

Enterprise Software ETL 

  • Informatica PowerCenter
  • IBM InfoSphere DataStage
  • Oracle Data Integrator (ODI)
  • Microsoft SQL Server Integration Services (SSIS)
  • SAP Data Services
  • SAS Data Manager, etc.

Open Source ETL 

  • Talend Open Studio
  • Pentaho Data Integration (PDI)
  • Hadoop, etc.


Discussion

No Comment Found