This is a text description of dwhsg127.gif, which shows the components in a Change Data Capture system that are of particular interest to the publisher. The image contains two sets of nested boxes. On the left side of the image is a box labeled "Source Database: HQ". Within that box is another box that contains two additional boxes, one labeled "Source Table: SH.SALES" and another labeled "Source Table: SH.PROMOTIONS". These innermost boxes contain the following lists:

• Source Table: SH.SALES

  • PROD_ID

  • CUST_ID

  • TIME_ID

  • PROMO_ID

  • QUANTITY_SOLD

  • AMOUNT_SOLD

• Source Table: SH.PROMOTIONS

  • PROMO_ID

  • PROMO_SUBCATEGORY

  • PROMO_CATEGORY

  • PROMO_COST

  • PROMO_END_DATE

  • PROMO_BEGIN_DATE

On the right side of the image is a box labeled "Staging Database: DW". Within that box is another box labeled "Change Source: HQ_SRC". Within that box, is another box labeled "Change Set: SH_SET". Within the Change Set box are two additional boxes, one labeled "Change Table: sales_ct" another labeled "Change Table: promo_ct". These innermost boxes contain the following lists:

• Change Table:sales_ct

  • PROD_ID

  • CUST_ID

  • TIME_ID

  • PROMO_ID

  • QUANTITY_SOLD

  • AMOUNT_SOLD

• Change Table: promo_ct

  • PROMO_ID PROMO_SUBCATEGORY PROMO_CATEGORY PROMO_END_DATE PROMO_BEGIN_DATE

There are three arrows in the image:

• One pointing left to right from the "Source Table: SH.SALES" box to the "Change Table: sales_ct" box

• One pointing left to right from "Source Table: SH.PROMOTIONS" box to the "Change Table: promo_ct" box

• One pointing right to left from the "Change Source: HQ_SRC" box to the "Source Database: HQ" box