invantive documentation
Invantive Support ForumsLog In / Sign Up

IncrementalLoadStatuses: Exact Online Incremental Loading Statuses

read only per partition

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

Status of incremental loading tables.

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 IncrementalLoadStatuses 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
AlgorithmVersion int32 Algorithm Version writable
CreatedUtc datetime Created (UTC) writable
DeletedRowsFoundCountLast int64 Last Deleted Rows Found Count 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 Total Download Duration Modified Rows (ticks) writable
DownloadDurationPreviousRowsLastTicks int64 Previous Last Download Duration Rows (ticks) writable
DownloadDurationPreviousRowsTotalTicks int64 Previous Total Download Duration Rows (ticks) writable
EventLogEntriesCount int32 Event Log Entries Count writable
MaxSeenTimestampCurrent int64 Last Seen Timestamp writable
MaxSeenTimestampCurrentDateTime datetime Last Seen Timestamp Registered at Date writable
MaxSeenTimestampPrevious int64 Previous Last Seen Timestamp writable
MaxSeenTimestampPreviousDateTime datetime Previous Last Seen Timestamp Registered at Date writable
MetadataHttpCacheId varchar2 Metadata HTTP Cache ID writable
PartitionCode varchar2 Partition Code writable
PartitionCompanyAddressLine1 varchar2 Address Line 1 writable
PartitionCompanyAddressLine2 varchar2 Address Line 2 writable
PartitionCompanyAddressLine3 varchar2 Company Address Line 3 writable
PartitionCompanyCity varchar2 Partition Company City writable
PartitionCompanyCoCNumber varchar2 CoC Number writable
PartitionCompanyCountry varchar2 Partition Company Country writable
PartitionCompanyEmailAddress varchar2 Partition Company Email Address writable
PartitionCompanyName varchar2 Partition Company Name writable
PartitionCompanyPhone varchar2 Partition Company Phone writable
PartitionCompanyPostalCode varchar2 Postal Code writable
PartitionCompanyVatNumber varchar2 VAT Number writable
PartitionCompanyWebSite varchar2 Website writable
PartitionCreatedUtc datetime Partition Created (UTC) writable
PartitionName varchar2 Partition Name writable
PartitionOwnerCompanyAddressLine1 varchar2 Owner Company Address Line 1 writable
PartitionOwnerCompanyCity varchar2 Owner Company City writable
PartitionOwnerCompanyCocNumber varchar2 Owner Company CoC Number writable
PartitionOwnerCompanyCode varchar2 Owner Company Code writable
PartitionOwnerCompanyCompanyWebSite varchar2 Owner Company Website writable
PartitionOwnerCompanyCountry varchar2 Owner Company Country writable
PartitionOwnerCompanyName varchar2 Partition Owner Company Name writable
PartitionOwnerCompanyPostalCode varchar2 Owner Company Postal Code writable
PartitionOwnerCompanyVatNumber varchar2 Owner Company VAT Number writable
RowCount int64 Rows writable
RowCountPrevious int64 Previous Row Count writable
ServiceUrlRequested varchar2 Service URL Requested writable
StatisticsCount int32 Statistics Count 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: