m (1 revision imported: Cleaned up for It. 6) |
|||
| Line 1: | Line 1: | ||
= View CTL_ETL_HWM = | = View CTL_ETL_HWM = | ||
| − | + | ||
| − | + | <onlyinclude> | |
| − | + | ||
| − | + | {{PDMView | |
| − | + | |viewName = CTL_ETL_HWM | |
| − | + | |shortDesc = | |
| − | + | |viewDesc = This view reflects processing progress for the data that is being transferred to the dimensional model tables, but for which certain interaction states are still in progress for the current time interval. | |
| − | + | ||
| − | + | In this release, the view is limited to the extracted configuration data and transformed multimedia data only. | |
| − | + | |introduced = | |
| − | + | |SQL = <source lang="xml" enclose="div">select | |
| − | + | 'TRANSFORM_MM' AS NAME, | |
| − | + | HWM_VALUE AS LAST_TS | |
| − | + | from CTL_TRANSFORM_HWM | |
| − | + | where HWM_NAME = 'GIDB_G_PARTY_HISTORY_MM' | |
| − | + | union | |
| − | + | select | |
| − | + | 'EXTRACT_CFG' AS NAME, | |
| − | + | min(MAX_TS) AS LAST_TS | |
| − | + | from CTL_EXTRACT_HWM | |
| − | + | where DATA_SOURCE_TYPE = 4 | |
| − | + | union | |
| − | + | select | |
| − | + | 'TRANSFORM_SM' AS NAME, | |
| − | + | min(HWM_VALUE) AS LAST_TS | |
| − | + | from CTL_TRANSFORM_HWM | |
| − | + | where HWM_NAME in ('STG_SM_RES_STATE_FACT_V','STG_SM_RES_STATE_FACT_MM') | |
| − | + | union | |
| − | + | select | |
| − | + | 'TRANSFORM_SM_V' AS NAME, | |
| − | + | min(HWM_VALUE) AS LAST_TS | |
| − | + | from CTL_TRANSFORM_HWM | |
| − | + | where HWM_NAME ='STG_SM_RES_STATE_FACT_V' | |
| − | + | union | |
| − | + | select | |
| − | + | 'TRANSFORM_SM_MM' AS NAME, | |
| − | + | min(HWM_VALUE) AS LAST_TS | |
| − | + | from CTL_TRANSFORM_HWM | |
| − | + | where HWM_NAME ='STG_SM_RES_STATE_FACT_MM' | |
| − | + | ||
| − | + | </source> | |
| − | + | }} | |
| − | + | ||
| − | + | {{PDMViewColumn | |
| − | + | |colName = NAME | |
| − | + | |colDesc = A combination of the job name and an abbreviated data type for the processed data. Either of the following values: | |
| − | + | * EXTRACT_CFG | |
| − | + | *TRANSFORM_MM}} | |
| − | + | ||
| − | + | {{PDMViewColumn | |
| − | + | |colName = LAST_TS | |
| − | + | |colDesc = Provides a UTC equivalent of the date and time up to which the data has been processed. | |
| − | + | }} | |
| − | + | ||
| − | + | </onlyinclude> | |
| − | + | [[Category:V:GIM:8.5DRAFT]] | |
Revision as of 18:17, August 18, 2016
View CTL_ETL_HWM
Description
This view reflects processing progress for the data that is being transferred to the dimensional model tables, but for which certain interaction states are still in progress for the current time interval.
In this release, the view is limited to the extracted configuration data and transformed multimedia data only.
Column List
| Column | Description |
|---|---|
| NAME | A combination of the job name and an abbreviated data type for the processed data. Either of the following values:
|
| LAST_TS | Provides a UTC equivalent of the date and time up to which the data has been processed. |
References
The summary List of References will include the following entries for this table or view:
There are no references from this table/view.
Comments or questions about this documentation? Contact us for support!