Revision as of 16:11, June 30, 2020 by Peter Chaplin (talk | contribs) (Update with the copy of version: DRAFT900)
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 | Key to the ETL_AUDIT dimension, identifying the corresponding Load Intraday job. |
| 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. |
This page was last edited on June 30, 2020, at 16:11.
Comments or questions about this documentation? Contact us for support!