Extract can be grouped into static extract and incremental extract. Static extract captures a snapshot of the source data at a point in time whereas incremental extract captures changes that have occurred since the last static extract.
Transform has three major steps i.e. data cleansing, data integration and other transformations ( such as derived values, replacement values and other aggregation calculations).
Loading: At this stage the transformed data is loaded into the data warehouse and index will be created. And loading can be at a refresh mode or update mode.
meda Selected answer as best 20/10/2022