Skip to main content

Views on comparison analysis results

  • TDQ_V_ALL_RUN_MATCH_ANALYSIS: contains all analysis primary keys with the calendar time

  • TDQ_V_LAST_MATCH_ANALYSIS_EXEC: contains the primary key of the last execution of each comparison analysis. This view uses TDQ_V_ALL_RUN_MATCH_ANALYSIS

  • TDQ_V_LAST_RUN_MATCH_ANALYSIS: 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_MATCH_ANALYSIS and TDQ_V_LAST_MATCH_ANALYSIS_EXEC

Detailed description of views:

TDQ_V_ALL_RUN_MATCH_ANALYSIS and TDQ_V_LAST_RUN_MATCH_ANALYSIS
  • 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_MATCH_ANALYSIS_EXEC
  • ANALYSIS_PK: foreign keys to the analysis dimension tables

  • LAST_RUNTIME: count of last version of the analyzed element

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!