Revision as of 11:15, June 23, 2020 by Peter Chaplin (talk | contribs)
ETL_STATS_DIMENSIONS System
The ETL_STATS_DIMENSIONS table records dimension data statistics of the iWD events inserted by the Load Intraday job.
| Field | Data Type | Description |
|---|---|---|
| ETL_AUDIT_KEY | int | Primary key field. it is a reference to to ETL_AUDIT system table. |
| DIMENSION_NAME | varchar(255) | The name of the dimension. |
| PARENT_ETL_AUDIT_KEY | int | Points to the first ETL_AUDIT_KEY in job run. |
| ETL_DATE | datetime | The timestamp when data is inserted. |
| NEW_COUNT | int | Total number of new keys that inserted into the dimension. |
| DISTINCT_COUNT | int | Total number of unique values. |
| NOT_CACHED_COUNT | int | Total number of not cached values. |
| CACHE_MISSED_COUNT | int | Total number of keys loaded back into cache from database. |
Comments or questions about this documentation? Contact us for support!