Views on overview analysis results - 7.1

Talend Real-time Big Data Platform Studio User Guide

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Real-Time Big Data Platform
task
Design and Development
EnrichPlatform
Talend Studio
  • TDQ_V_ALL_RUN_OVERVIEW_ANALY: contains all analysis primary keys with the calendar time

  • TDQ_V_LAST_OVERVIEW_ANALY_EXEC: contains the primary key of the last execution of each overview analysis. This views uses TDQ_V_ALL_RUN_OVERVIEW_ANALY

  • TDQ_V_LAST_RUN_OVERVIEW_ANALY: contains the primary key of the last execution of each analysis alongside with the time execution information and the foreign keys to calendar and time dimensions. This view uses TDQ_V_ALL_RUN_OVERVIEW_ANALY and TDQ_V_LAST_OVERVIEW_ANALY_EXEC

Detailed description of views:

TDQ_V_LAST_RUN_OVERVIEW_ANALY and TDQ_V_ALL_RUN_OVERVIEW_ANALY
  • ANALYSIS_PK: foreign keys to the analysis dimension table

  • CAL_PK: foreign keys to the execution date of the analysis

  • TIME_PK: foreign keys to the execution time of the analysis

  • AN_RUNTIME: execution date of the analysis

TDQ_V_LAST_OVERVIEW_ANALY_EXEC
  • ANALYSIS_PK: foreign keys to the analysis dimension table

  • Last_RUNTIME: count of last version of the analyzed element