The Set Extractor Extraction Report dialog box is designed to write out to a file the information displayed on the Table Statistics Tab. Such reports can be used to permanently record the extract and are also useful as feedback when designing Extraction Sets using the Set Designer application.
The Extraction Report can also include optional information such as the total extraction time (in seconds) for all rule applied to the table, the average number of rows extracted per second and the number of rules extracting rows for that table.
Extraction Report Sample
DATABEE EXTRACTION REPORT
DataBee Version: v03.00 beta 10
Report Written: Tue 25 Feb 2003, 09:30
Extraction Started: Tue 25 Feb 2003, 09:26
Extraction Finished: Tue 25 Feb 2003, 09:26
Extraction Duration: 0:00:08
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 out 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