ETL (Extract, Transform and Load) is a process in data warehousing responsible for pulling data out of the source systems and placing it into a data warehouse.
The data is loaded in the DW system in the form of dimension and fact tables.
Extracting the data from source systems (SAP, ERP, other operational systems) and then data is converted into one consolidated data warehouse format which is ready for transformation processing.
Data is extracted from the source system and kept it in the staging area.
Staging area is required when you want to get the data from multiple data sources together or if you want to join two or more systems together. For example, you will not be able to perform a SQL query joining two tables from two physically different databases.
In data transformation, you apply a set of functions on extracted data to load it into the target system. Data, which does not require any transformation is known as direct move or pass through data.
During Load phase, data is loaded into the end-target system and it can be a flat file or a Data Warehouse system.
See also Dimension and Fact Tables
If you like dEexams.com and would like to contribute, you can also write your article here or mail your article to firstname.lastname@example.org . See your article appearing on the dEexams.com main page and help others to learn.
Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.