Views on overview analysis results - Cloud - 7.3

Talend Studio User Guide

Version
Cloud
7.3
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Available in...

Big Data Platform

Data Fabric

Data Management Platform

Data Services Platform

MDM Platform

Real-Time Big Data Platform

  • 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