The Set Loader Table Statistics tab is designed to provide information on the number of rows loaded for each table and the rate at which those rows have been loaded. The statistics are continuously updated during the load operations and the count displayed on this tab is an accurate reflection of the number of rows that have
been loaded and committed in the target schema.
Only tables which have had data extracted by an extraction set run on a source schema by the Set Extractor application can have data loaded for them. All table loading operations are controlled and configured via a Load Manager rule.
A useful report detailing the contents of the Table Statistics tab can be generated using the Loader Table Statistics Report button on the Misc. Setup tab of the Set Loader application. This report can be auto-generated after each run of the loader set using the Loader Report Options sub-tab on the Set Designer Misc. Setup Tab.
The DataBee Set Loader Table Statistics Tab
The panel in the the Table Statistics tab lists the tables configured in the Load Manager rules of the currently open loader set. The panel is divided up into eight vertical columns. These columns provide specific information on various statistics associated with the table. Clicking on the column heading sorts the display based on the information in that column.
What the columns in the Table Statistics Panel mean
- Tables in the Loader Set
- This column shows table name. The schema owner of the table is determined by the Rule Controller to which it belongs. Because there can be more than one Rule Controller in a loader set each table is displayed as a dependency below its Rule Controller.
- Load State column
- An indication of the loaded state for each table. Note that the load state will be Not Run if there were no extracted rows to load for that table.
- Was Extracted
- A simple true or false column indicating if there are any extracted rows for that table in the source schema. This field will only be updated once the loader set has begun to execute.
- Extracted Rows column
- This column shows the number of rows that were extracted in the source schema for each table. This number is static -
ROWID's for the extracted rows are placed in the source schema temporary tables by the Set Extractor application and these are simply counted up at the beginning of the loader set execution to derive this number.
- Loaded Rows column
- This column shows the number of currently loaded and committed rows for each table. This figure will be continuously updated as the
- Delta Rows
- If you have performed a delta load (a load of additional information into a pre-existing schema) this column will show the number of newly loaded and committed rows for each table. This figure will be continuously updated as the delta load progresses.
- Percent column
- This value is the number of loaded rows divided by the number of extracted rows expressed as a percentage and serves to indicate how far the load operations for that table have progressed.
- Rows/Second
- This figure is the number of rows per second loaded into the target table.
- Errors
- Each line describing a table has a button in the Errors column. If an error occurred during the load of the rows, this button will change to a red X indicating that the load process had errors. Pressing on the button will launch a diagnostic form which displays diagnostic and debugging information regarding the error.
