invantive documentation
Invantive Support ForumsLog In / Sign Up

dc_fact_size_statistics: Data Cache Fact Size Statistics

read only

  • Catalog: Cache
  • Schema: Invantive
  • Label: Fact Size Statistics

Statistics on the size of facts.

Can only retrieve data.

Table Columns

The columns of the table dc_fact_size_statistics 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
dcr_name varchar2(240) Data Container ID Name of the data container.
fsc_active_count_partitions decimal Size of Active Versions (partitions) Total number of partitions in active versions.
fsc_active_size_characters_m decimal Size of Active Versions (million characters) Total number of characters in millions in active versions.
fsc_active_size_rows_m decimal Size of Active Versions (million rows) Total number of rows in millions in active versions.
fsc_deleted_count_partitions decimal Size of Deleted Versions (partitions) Total number of partitions in deleted versions.
fsc_deleted_size_characters_m decimal Size of Obsoleted Versions (million characters) Total number of characters in millions in deleted versions.
fsc_deleted_size_rows_m decimal Size of Deleted Versions (million rows) Total number of rows in millions in deleted versions.
fsc_obsoleted_count_partitions decimal Size of Obsoleted Versions (partitions) Total number of partitions in obsoleted versions.
fsc_obsoleted_size_characters_m decimal Size of Obsoleted Versions (million characters) Total number of characters in millions in obsoleted versions.
fsc_obsoleted_size_rows_m decimal Size of Obsoleted Versions (million rows) Total number of rows in millions in obsoleted versions.
fsc_total_count_partitions decimal Size of All Versions (partitions) Total number of partitions.
fsc_total_size_characters_m decimal Size of All Versions (million characters) Total number of characters in millions.
fsc_total_size_rows_m decimal Size of All Versions (million rows) Total number of rows in millions.
tbe_facts_table_name varchar2(30) Facts Table Name Name of the facts table with last downloaded data for this table.
tbe_full_qualified_name varchar2(240) Full Qualified Name Full qualified name of the table to be downloaded.

Release Notes

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