Views on dimensions - Cloud - 8.0

Talend Studio User Guide
Version
Cloud
8.0
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
Last publication date
2024-04-16
Available in...

Big Data Platform

Data Fabric

Data Management Platform

Data Services Platform

MDM Platform

Real-Time Big Data Platform

  • TDQ_V_LAST_ANALYSIS: contains the analysis and the report identifiers with the last version number of the analysis dimension (because TDQ_ANALYSIS is a Slowly Changing Dimension, each analysis can have several versions).

  • TDQ_V_ANALYSIS: view on the last version of the analysis data. This view uses TDQ_V_LAST_ANALYSIS

  • TDQ_V_LAST_ANALYZED_ELEMENT: contains the analyzed element identifier alongside with the last version number of the analyzed element dimension

  • TDQ_V_ANALYZED_ELEMENT: view on the last version of the analyzed element. This view uses TDQ_V_LAST_ANALYZED_ELEMENT

  • TDQ_V_LAST_INDICATOR_DEF: contains the indicator definition identifier alongside with the last version number of the indicator definition dimension

  • TDQ_V_INDICATOR_DEFINITION: view on the last version of the indicator definition. This view uses TDQ_V_LAST_INDICATOR_DEF

  • TDQ_V_SIMPLE_INDICS: This view filters the simple statistics indicators. It uses TDQ_V_INDICATOR_DEFINITION

Detailed description of views:

TDQ_V_ANALYSIS, TDQ_V_ANALYZED_ELEMENT and TDQ_V_INDICATOR_DEFINITION have the same attributes (columns) as TDQ_ANALYSIS, TDQ_ANALYZED_ELEMENT and TDQ_INDICATOR_DEFINITION respectively. For further information, see Detailed description of tables

TDQ_V_LAST_ANALYSIS

  • AN_UUID: analysis identifier

  • REP_UUID: report identifier

  • LAST_VERSION: last version of the analysis

TDQ_V_LAST_ANALYZED_ELEMENT

  • ELT_UUID: identifier of the analyzed element

  • LAST_VERSION: last version of the analyzed element

  • ELT_CTX_GROUP_ID: the context group id of the analyzed element

  • ELT_CTX_NAME: the context name of the analyzed element

TDQ_V_LAST_INDICATOR_DEF

  • IND_UUID: indicator identifier

  • LAST_VERSION: last version of the identifier

TDQ_V_SIMPLE_INDICS

  • IND_PK: primary key

  • IND_UUID: indicator identifier

  • IND_LABEL: indicator label

  • IND_CATEGORY: indicator category.

    Simple indicators such as count indicators belong to the Simple Statistics category, Count subcategory. Text indicators belong to the Text Statistics category. Mean, Median, Lower quartile, upper quartile, min value, max value belong to the Summary Statistics category. Mode belong to the Advanced Statistics category and Mode subcategory. Frequency table belong to the Advanced Statistics category and Frequencies subcategory.

  • IND_CATEG_UUID: category identifier

And the three historization columns:

  • IND_BEGIN_DATE

  • IND_END_DATE

  • IND_VERSION