DWD – How Data Flows Into the Warehouse
Common Process plays a VERY important role of building the dimension tables which have all the keys, the fact tables will refer to when they are built.
Perm_load job loads any tables that store permanent data (large tables that shouldn’t change once created).
Perm_extract job “primes the pump” for the module loads by looking for changes to perm_tables and preparing the data to be loaded in extract tables.
The various modules process jobs load for their respective modules.
The Rollup jobs populate the snapshots and the performance tables.