invantive documentation
Invantive Support ForumsLog In / Sign Up

IncrementalLoadStatistics: Exact Online Incremental Loading Statistics

read only per partition

  • Catalog: ExactOnlineDataDictionary
  • Schema: DataDictionary
  • Label: Incremental Loading Statistics

Status of incremental loading statistics.

The data in this table is partitioned per value of the Division column.

Can only retrieve data.

Performance Characteristics

Characteristic Value
Average access latency (ms) 432
Full scan rows per minute 50,300
Point query rows per minute 138

Table Columns

The columns of the table IncrementalLoadStatistics are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
BillingId varchar2 Billing ID writable
BillingPoolIdentityId varchar2 Billing Pool Identity ID writable
CreatedUtc datetime Created (UTC) writable
DeletedRowCount int64 Deleted Rows Count writable
DeletedRowIDs varchar2 Deleted Row IDs writable
DeletedRowsFoundCountTotal int64 Total Deleted Rows Found Count writable
DownloadDurationDeletedRowsLastTicks int64 Last Download Duration Deleted Rows (ticks) writable
DownloadDurationDeletedRowsTotalTicks int64 Total Download Duration Deleted Rows (ticks) writable
DownloadDurationModifiedRowsLastTicks int64 Last Download Duration Modified Rows (ticks) writable
DownloadDurationModifiedRowsTotalTicks int64 Last Download Duration Modified Rows (ticks) writable
DownloadDurationPreviousRowsLastTicks int64 Previous Last Download Duration Rows (ticks) writable
DownloadDurationPreviousRowsTotalTicks int64 Previous Last Download Duration Rows (ticks) writable
GuiAction varchar2 GUI Action writable
GuiExternalIpV6Address varchar2 Gui External IP Address writable
GuiModuleName varchar2 GUI Module Name writable
GuiModuleVersion varchar2 GUI Module Version writable
MaxSeenTimestampCurrent int64 Last Seen Timestamp writable
MaxSeenTimestampCurrentDateTime datetime Last Seen Timestamp Registered at Date writable
NewRowsCount int64 New Rows Count writable
NumberOfDataFiles int32 Of Data Files writable
OldRowsDeletedCount int64 Old Rows Deleted Count writable
OldRowsIncludedModifiedCount int64 Old Rows Included Modified Count writable
OldRowsIncludedUnchangedCount int64 Old Rows Included Unchanged Count writable
ParentUid guid Parent Uid writable
PartitionCompanyName varchar2 Partition Company Name writable
RequestId varchar2 Request ID writable
RowCount int64 Rows writable
RowCountPrevious int64 Previous Row Count writable
ServiceUrlRequested varchar2 Service URL Requested writable
SessionId varchar2 Session ID writable
StatusAlgorithmVersion int32 Status Algorithm Version writable
StatusCreatedUtc datetime Status Created (UTC) writable
StatusDeletedRowsFoundCountLast int64 Status Deleted Rows Found Count Last writable
StatusDeletedRowsFoundCountTotal int64 Status Deleted Rows Found Count Total writable
StatusDownloadDurationDeletedRowsLastTicks int64 Status Download Duration Deleted Rows Last Ticks writable
StatusDownloadDurationDeletedRowsTotalTicks int64 Status Download Duration Deleted Rows Total Ticks writable
StatusDownloadDurationModifiedRowsLastTicks int64 Status Download Duration Modified Rows Last Ticks writable
StatusDownloadDurationModifiedRowsTotalTicks int64 Status Download Duration Modified Rows Last Ticks writable
StatusDownloadDurationPreviousRowsLastTicks int64 Status Download Duration Previous Rows Last Ticks writable
StatusDownloadDurationPreviousRowsTotalTicks int64 Status Download Duration Previous Rows Last Ticks writable
StatusEventLogEntriesCount int32 Status Event Log Entries Count writable
StatusMaxSeenTimestampCurrent int64 Status Maximum Seen Timestamp Current writable
StatusMaxSeenTimestampCurrentDateTime datetime Status Maximum Seen Timestamp Current Date Time writable
StatusMaxSeenTimestampPrevious int64 Status Maximum Seen Timestamp Previous writable
StatusMaxSeenTimestampPreviousDateTime datetime Status Maximum Seen Timestamp Previous Date Time writable
StatusPartitionCode varchar2 Status Partition Code writable
StatusPartitionCompanyCity varchar2 Status Partition Company City writable
StatusPartitionCompanyCountry varchar2 Status Partition Company Country writable
StatusPartitionCompanyEmailAddress varchar2 Status Partition Company Email Address writable
StatusPartitionCompanyName varchar2 Status Partition Company Name writable
StatusPartitionCompanyPhone varchar2 Status Partition Company Phone writable
StatusPartitionCreatedUtc datetime Status Partition Created (UTC) writable
StatusPartitionName varchar2 Status Partition Name writable
StatusPartitionOwnerCompanyName varchar2 Status Partition Owner Company Name writable
StatusRowCount int64 Status Row Count writable
StatusRowCountPrevious int64 Previous Status Row Count writable
StatusServiceUrlRequested varchar2 Status Service URL Requested writable
StatusStatisticsCount int32 Status Statistics Count writable
StatusTableNameRequested varchar2 Status Table Name Requested writable
StatusTimestampEnvironment varchar2 Status Timestamp Environment writable
StatusUid guid Status UID writable
StatusVersion int32 Status Version writable
TableNameRequested varchar2 Table Name Requested writable
TimestampEnvironment varchar2 Timestamp of Environment writable
Uid guid UID writable
Version int32 Version writable

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: