Extract-Transformation-Load (ETL):

• Extraction is an initial step to bring the needed data to staging area for further process
• Transformation process involves converts the data to accurate, resolving duplicate, dealing with missing elements, eliminates duplicates and assign data warehouse keys, normalize the data structure etc.,
• Loading takes the form of presenting the dimension table to the bulk loading facilities of each data mart