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.