This is a text description of pub_components.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 appear as follows:

• 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 System: 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 appear as follows:

• 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 arrow in the image, as follows:

• One from the "Source Table: SH.SALES" box to the "Change Table: sales_ct box"
• One from "Source Table: SH.PROMOTIONS" box to the "Change Table: promo_ct" box
• One from the "Change Source: HQ_SRC" box to the "Source Database: HQ" box

End of description.