Creating and Managing SQL Scripts - Microsoft Business Intelligence Tools for Excel Analysts - page 198

Figure 10-6: Data Delivery tables.

Figure 10-7: Extract tables.

The structure of this phase mirrors the source system almost exactly. The only exception is Extract.
ReoccurringPayment. The OrderDate is needed because you need to use that column to produce the
two analytics requirements outlined in the example definition.

Listing 10-1 shows the data extraction script. It starts by defining a From and To incremental
window of time for updating your system. This window must be maintained in your logging table
and updated at the end of each run. Notice that the target table is truncated prior to insert.

You can make this step more robust by adding a unique constraint on the Extract.
Customer table if you are concerned about data integrity.

Tip