Revisions Spec Exercise: Map Source to Target

This exercise walks you through the process of adding a revision to map source (OLTP database) to target (warehouse and staging tables). Mappings are established through comments on the table and columns. Using comments instead of keys helps to optimize performance. You can use the examples included in this guide to help you. This exercise assumes an installed Blackbaud Data Warehouse database and a revisions spec created in the previous exercise.

Revisions Spec Exercise Steps: Map Source to Target