Difference between Teradata Utilities and ETL Process

Database
Enthusiast

Difference between Teradata Utilities and ETL Process

I am sort of confused in differentiating between teradata utilities such as FastLoad and MLoad that are used for loading external data into teradata tables and ETL process. I understand ETL processing is Extract Transform and Load. But what exactly is involved in etl processing.

Thanks.
Pervez Ahmed
3 REPLIES
Enthusiast

Re: Difference between Teradata Utilities and ETL Process

This Wikipedia article may be helpful: http://en.widipedia.org/wiki/Etl
Enthusiast

Re: Difference between Teradata Utilities and ETL Process

I am reviewing the link. Thanks a lot for your respons.
Pervez Ahmed
Enthusiast

Re: Difference between Teradata Utilities and ETL Process

The process of ETL using Teradata utilities will be ELT
Extract, Load and Transform
so, the loading will be done through Fast load, Multi load and the transofmations can be done using Bteq scripts :-)