Jump to: navigation, search

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:
  • EXTRACT_CFG
  • TRANSFORM_MM
LAST_TS Provides a UTC equivalent of the date and time up to which the data has been processed.

SQL Query

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'

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on August 29, 2016, at 13:59.