TDQ_V_ALL_RUN_MATCH_ANALYSIS
: contains all analysis primary keys with the calendar timeTDQ_V_LAST_MATCH_ANALYSIS_EXEC
: contains the primary key of the last execution of each comparison analysis. This view usesTDQ_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 usesTDQ_V_ALL_RUN_MATCH_ANALYSIS
andTDQ_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 tableCAL_PK
: foreign keys to the execution date of the analysisTIME_PK
: foreign keys to the execution time of the analysisAN_RUNTIME
: execution date of the analysis
TDQ_V_LAST_MATCH_ANALYSIS_EXEC
ANALYSIS_PK
: foreign keys to the analysis dimension tablesLAST_RUNTIME
: count of last version of the analyzed element