Extract/Transform/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 (1 becomes "Male" 2 becomes "Female"), and loading the data into some form of the data warehouse (ODS, enterprise data warehouse, data mart). ETL can also refer to the vendor software that performs these processes.
The process of extracting operational data, transforming it into a standardized format, and loading it into a repository for analysis, typically a data warehouse or data mart.
extract transform load. The processes that enable companies to move data from multiple sources, reformat and cleanse it, and load it into another database, a data mart, or a data warehouse for analysis or onto another operational system to support a business process.
Extract, Transform, Load. Three database functions that are combined into one tool to pull data out of source databases and place it into target databases. ETL is used to migrate data from databases to others, to form data marts and data warehouses and also to convert databases from one format or type to another. Extract—the process of reading data from databases. Transform—the process of converting the extracted data from its previous form into the form it needs to be in so that it can be placed into other databases. Transformation occurs by using rules or lookup tables or by combining the data with other data. Load—the process of writing the data into the target databases.
Extraction, Transformation and Loading. Activities required to populate data warehouses and OLAP applications with clean, consistent, integrated and probably summarized data.
ETL stands for Extract, Transform and Load. When data is loaded into a central data warehouse, it goes through three stages. First, the data is obtained from the source. Next, it is transformed and cleaned for the target database. Finally, it is loaded into the data warehouse.
Extract Transform Load Process for populating a data warehouse or data mart
Extraction, transformation, and loading. ETL refers to the methods involved in accessing and manipulating source data and loading it into a data warehouse. The order in which these processes are performed varies. Note that ETT (extraction, transformation, transportation) and ETM (extraction, transformation, move) are sometimes used instead of ETL. See Also: data warehouse extraction transformation transportation
ETL (extract, transform, load) software does just that it extracts records/fields from one data source, converts the data to new formats and provides the ability to load the data to other target destinations, in other words data handling and processing that precedes final storage in the repository.
The acronym for Extraction, Transformation, and Load. The tool extracts, transforms and loads data from data sources to data targets in a central repository. The data sources can be a database, file, or COBOL copybook or any combination of the three. It will be primarily used to move data from an OLTP to an ODS or an ODS to a DSS.
Extract, Transform, and Load. Tool and processes to extract, transform, and load operational data into a relational store and manage these processes.
See extract, transform, and load (ETL).
Technologies that extract raw data from one or more data sources (transactional systems, databases, etc.), transform and merge data into new data structures and load it into a data warehouse or equivalent system where it can be accessed by end users to analyze the business.
ETL refers to the process of getting data out of one data store (extract), modifying it (transfer), and inserting it into a different data store (load).
Related Terms: content mining, meta tagging, scraping A process of gathering, converting and storing data, often from many locations. The data is often converted from one format to another in the process. Officially, ETL is an abbreviation for "Extract, Transform and Load"
Data Warehouse acquisition processes of Extracting, Transforming (or Transporting) and Loading ( ETL) data from source systems into the data warehouse.
the generic name for software which xtracts, ransforms and oads data.
Extract, Transform and Load - usually loading data from different sources into, perhaps, a Data Warehouse for business Intelligence purposes.