ETL (or EL-T, that is, Extract, Load and Transform) first concentrates information from the first ever sources, guarantees the nature of the information, cleans the information, and makes the information dependable over the first ever sources. ETL then populates the physical articles with the "clean" information so question devices, report authors, dashboards et cetera can access the information.
- Data sourcing
- Data development
- Data conversion
- Data stacking
From a sensible structural engineering view, there are numerous diverse approaches to design these building pieces for conveying information procurement administrations. The significant structural styles accessible that blanket a reach of choices to be focused inside an information warehousing building design incorporate:
Batch Extract, Transform, and Load and Batch Extract, Load, Transform, Load
