Answered by sunitha on 2005-04-28 21:17:53: ETL is extraction,trasformation and loading,ETL technology is used for extraction the information from the source database and loading it to the target database with the necessary trasformations done in between.
ETL is an abbreviation for "Extract, Transform and Load".This is the process of extracting data from their operational data sources or external data sources, transforming the data which includes cleansing, aggregation, summarization, integration, as well as basic transformation and loading the data into some form of the data warehouse.
Above answer was rated as good by the following members: ankeshjain
ETL is extraction,trasformation and loading,ETL technology is used for extraction the information from the source database and loading it to the target database with the necessary trasformations done in between.
ETL is a short for Extract, Transform and Load. It is a data integration function that involves extracting the data from outside sources , transforming it into business needs and ultimately loading it into a datawarehouse
ETL is an abbreviation for "Extract, Transform and Load".This is the process of extracting data from their operational data sources or external data sources, transforming the data which includes cleansing, aggregation, summarization, integration, as well as basic transformation and loading the data into some form of the data warehouse.
It is used to Extact the data from sources, source can be anything like COBOL, XML, Flat File. and Transforming the extract data by doing some transformations and Loading the Transform data into the Target Table.
The full form of ETL is Extraction, Transform, Loading.
E stands for Extraction : The meaning of 'E' in ETL is that it extract the data
from different source system such as Oracle, SQL Server, Flat files, XML files,
Cobol files etc.
T stands for Transform : The meaning of 'T' in ETL is that it transform the data
according to the business needs with the help of the transformation/mappings.
L stands for Loading : The meaning of 'L' in ETL is that it loads the data into
the target table.
Data Acquisition technique is now called ETL(Extraction, Transformation and Loading)Extraction-The process of extracting the data from various sources. Sources can be file system, database, XML file, Cobol File, ERP etcTransformation-Transforming the data(in Staging Area) as per business logic or requirement.
Loading-Loading the transformed or untransformed data into the target.
1 
0