over 9 years ago
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.
Can you help out the community by solving one of the following Manual Testing problems?
Do activity (Answer, Blog) > Earn Rep Points > Improve Rank > Get more opportunities to work and get paid!
For more topics, questions and answers, please visit the Tech Q&A page.
0 Comment(s)