What is ETL

ETL is extraction,transformation and loading,ETL technology is used for extraction the information from the source database and loading it to the target database with the necessary transformations done in between.

Showing Answers 1 - 18 of 18 Answers

sunitha

  • Apr 28th, 2005
 

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.

  Was this answer useful?  Yes

Meenal

  • Jul 14th, 2005
 

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

  Was this answer useful?  Yes

Ajay

  • Jul 26th, 2005
 

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.

        E: Extraction of data from the homogeneous/heterogenous sources.

        T: Transforming/modifying the source data by applying some transformations like Filter, Expression, Router, Joiner, Union (or) Lookup.

         L: Loading the Transformed data into corresponding Target tables.

  Was this answer useful?  Yes

smitha

  • Jul 19th, 2006
 

ETL ->Extraction Transformation Loading

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.

  Was this answer useful?  Yes

siraj khan

  • Aug 6th, 2007
 

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 etc Transformation-Transforming the data(in Staging Area) as per business logic or requirement.

Loading-Loading the transformed or untransformed data into the target.

  Was this answer useful?  Yes

rsp2709

  • Jun 8th, 2009
 

ETL is a process that extracts data from one database, transforms it as per the destination database and loads it into another database. In the transformation process, data is actually standardized to make it compatible with the destination database. Also many cleansing operations can be performed in the transformation section.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.