What are the benefits of using ETL tools over Teradata?

1.	What are the benefits of using ETL tools over Teradata?
Answer» Extract, Transform, Load (ETL) means three distinct tasks for managing databases. ETL tools offer some ADVANTAGES over Teradata, including: Support for multiple heterogeneous destinations and sources of data. The ETL tools provide a full-featured GUI that simplifies the DEBUGGING process for managing databases. ETL tools offer the advantage of being able to reuse components. Thus, if the main server is UPDATED, all corresponding applications CONNECTED to the server are AUTOMATICALLY updated. ETL tools can be used to pivot (transform rows into columns) and de-pivot (transform columns into rows).

Answer»

Extract, Transform, Load (ETL) means three distinct tasks for managing databases. ETL tools offer some ADVANTAGES over Teradata, including:

Support for multiple heterogeneous destinations and sources of data.
The ETL tools provide a full-featured GUI that simplifies the DEBUGGING process for managing databases.
ETL tools offer the advantage of being able to reuse components. Thus, if the main server is UPDATED, all corresponding applications CONNECTED to the server are AUTOMATICALLY updated.
ETL tools can be used to pivot (transform rows into columns) and de-pivot (transform columns into rows).

Discussion