What are important components of ETL Tool

What are important components of ETL Tool

What are important components of ETL Tool ?

ETL or Extract Transformation or Load is mainly used for extractomg or collecting data from different data sources, transformed the collected data as per business requirement and load the clean data in target databse. A good ETL tool are able to perform below task

  • Read the data from different types of sources
    • Able to connect with different types of database. Ex: SQL Server, Orcalse, Teradata, MySQL, etc
    • Able to read different types of files. Ex: text, excel, csv, xml, etc
  • Trasfomred the data as per business requirements. Able to convert data in different format. Prevent data loss. Provide a mechanism for complex calculation.
  • Load the data target database or flat file.

 

0 Comments
Leave A Comment

Please login to post your valuable comments.

Join the newsletter

Get the latest vLemonn news first

share