ETL Processes

Understand the ETL process that extracts, transforms, and loads the data into EDWs, DMs, and ODSs. If there are Extract, Transform, Load (ETL) processes in effect that update the data stores, it is useful to understand the frequency of the updates, the time of the updates, and the length of time for the updates to complete. This will impact applications or batch type reports that depend on the availability of real-time data.


Information Builders