Summary

Now we are real close to actually having a data warehouse built in our database. We've completed all the mappings that we will need for the Warehouse Builder to create the code that will run to actually pull data from our source system, load our staging table, and then load our target data warehouse structure from our staging table.

We've seen how to use Transformation Operators to apply functions to our data to change it before loading. We've also seen the Expression operator for entering custom expressions. We've taken a look at how to connect them together with source and target operators to complete a mapping and successfully validate them.

Now we're ready to deploy these mappings to the database and execute them to actually load our data, which we will do in the next chapter.