Meaning Of ETL:-
ETL,simple meaning of ETL is - Extract-Transform-Load. ETL is a procedure by which data or information is loaded from the source or origin system to the data warehouse. Data or information is removed from an OLTP database and then converted to correspond data warehouse schema and loaded into the data warehouse database.
E - Extract
T - Transform
L - Load
Extract:- The main purpose of this is, extract to the relevant data. Or extract information or data from the source or origin system.
Transform:- The main purpose of this is, transform or change the data to data warehouse format. Or use functions to fulfill data to an established dimensional schema.
Load:- The main purpose of this is, load the data into the data mart for exhaustion Or load data into data warehouse.
0 Comment(s)