DWH staging area serves the following key purposes:

- Pointing to source data tables
- Listing available columns
- Generating surrogate keys
- Simple joins are performed
- Rows are filtered

https://kzzzr.github.io/Populating-DWH-staging-area/