Description of the illustration dwhsg025.eps
This figure illustrates four steps in a multistage data transformation:
-
Load into staging table
-
Validate customer keys (in this case, by using the customer dimension table)
-
Convert source product keys to warehouse keys
-
Insert into the warehouse table
Before loading, you start with flat files. After loading, the data is in the table.