The Row Count Report Dialog Box

The Set Designer Row Count Report dialog box is designed to write out to a file the information displayed on the Table Row Counts dialog box. Such reports can be used as a printed reference when designing a set and are also useful as a permanent record of the source schema state.

What the options mean

Source Rows

The Source Rows column indicates the number of rows the table contains in the source schema. If no information is available the column will contain a "?" character.

Extracted Rows

The Extracted Rows column indicates the number of rows the table received in the last extract. The Extracted Rows file is produced automatically by the DataBee Set Extractor application and is automatically associated with the Extraction Set name. If no Extracted row information is available the column will contain a "?" character.

Row Count Report Sample

 DATABEE SET TABLES REPORT

 DataBee Version:      v03.00 beta 10
 Report Written:       Mon 24 Feb 2003, 17:35
 Extraction Set:       C:\Program Files\DataBee\DataBee Extraction Sets\sampleX.set
 Schema File:          samplex.schema
 Row Count File:       samplex.rowcount
 Total Source Rows:    2821
 Total Extracted Rows: 576

User Name  Table Name                Set Source Rows    Extracted Rows
---------- ------------------------- --- -------------- --------------

SRC_BILL   DTB_DISCOUNT               in 11             4
           DTB_INVOICE                in 300            76
           DTB_INVOICE_LINE           in 1000           206
           DTB_INVOICE_LINE_HISTORY   in 0              0
           DTB_INVOICE_STATUS         in 4              3

SRC_CUST   DTB_CUSTOMER               in 10             9
           DTB_POSTCODE               in 100            7
           DTB_SUPPLIER               in 90             0
           DTB_WEEKNUMBER             in 20             0

SRC_INVN   DTB_INVENTORY_ITEM         in 290            114
           DTB_ITEM_X_CUSTOMER_AGG   out 459            0

SRC_WARE   DTB_WAREHOUSE              in 4              4
           DTB_WAREHOUSE_STOCK_HK     in 124            32
           DTB_WAREHOUSE_STOCK_LA     in 98             33
           DTB_WAREHOUSE_STOCK_LO     in 143            36
           DTB_WAREHOUSE_STOCK_NY     in 168            52