Target Table Load Analysis(Last Month)

Displays the load statistics for each table for last month by repository by folder. This is a primary report in an analytic workflow.

Click on the text to copy the query report to your clipboard.


select "MAPPING_NAME",
"SESSION_NAME",
"FAILED_ROWS",
"REPOSITORY_NAME",
"TABLE_BUSNAME",
"SESSION_INSTANCE_ID",
"SUBJECT_AREA",
"SESSION_INSTANCE_NAME",
"SUCCESSFUL_ROWS",
"WIDGET_NAME",
"WORKFLOW_NAME",
"START_TIME",
"SUCCESSFUL_AFFECTED_ROWS"
from (SELECT  SESSION_REPOSIT_INFO.REPOSITORY_NAME,  TO_CHAR(SESSION_TBL_LOG.START_TIME,'MON-YYYY') as "START_TIME",  ALL_SESSIONS.SUBJECT_AREA,  SESSION_LOG.WORKFLOW_NAME,  ALL_SESSIONS.SESSION_NAME,  SESSION_LOG.SESSION_INSTANCE_NAME,  SESSION_LOG.MAPPING_NAME,  SESSION_TBL_LOG.WIDGET_NAME,  SESSION_TBL_LOG.TABLE_BUSNAME,  (SUM(SESSION_TBL_LOG.SUCCESSFUL_ROWS)) as SUCCESSFUL_ROWS,  (SUM(SESSION_TBL_LOG.FAILED_ROWS)) as FAILED_ROWS,  (SUM(SESSION_TBL_LOG.SUCCESSFUL_AFFECTED_ROWS)) as SUCCESSFUL_AFFECTED_ROWS,  (COUNT(SESSION_TBL_LOG.SESSION_INSTANCE_ID)) as SESSION_INSTANCE_ID  FROM  REP_SESS_LOG SESSION_LOG,  REP_SESS_TBL_LOG SESSION_TBL_LOG,  REP_LOAD_SESSIONS ALL_SESSIONS,  REP_REPOSIT_INFO SESSION_REPOSIT_INFO  WHERE  (SESSION_LOG.SESSION_ID = SESSION_TBL_LOG.SESSION_ID AND  SESSION_LOG.TASK_VERSION_NUMBER = SESSION_TBL_LOG.SESSION_VERSION_NUMBER AND  SESSION_LOG.INSTANCE_ID = SESSION_TBL_LOG.SESSION_INSTANCE_ID AND  SESSION_TBL_LOG.START_TIME >= SESSION_LOG.ACTUAL_START AND  SESSION_TBL_LOG.START_TIME <= SESSION_LOG.SESSION_TIMESTAMP AND  ALL_SESSIONS.SESSION_ID = SESSION_LOG.SESSION_ID AND  ALL_SESSIONS.SESSION_VERSION_NUMBER = SESSION_LOG.TASK_VERSION_NUMBER AND  ALL_SESSIONS.SESSION_ID <> SESSION_REPOSIT_INFO.REPOSITORY_ID) AND  (TO_CHAR(SESSION_TBL_LOG.START_TIME,'MON-YYYY') = TO_CHAR(TO_DATE('01'||TO_CHAR(SYSDATE,'MON-YY'),'DD-MON-YY')-1,'MON-YYYY') )   GROUP BY  SESSION_REPOSIT_INFO.REPOSITORY_NAME,  TO_CHAR(SESSION_TBL_LOG.START_TIME,'MON-YYYY'),  ALL_SESSIONS.SUBJECT_AREA,  SESSION_LOG.WORKFLOW_NAME,  ALL_SESSIONS.SESSION_NAME,  SESSION_LOG.SESSION_INSTANCE_NAME,  SESSION_LOG.MAPPING_NAME,  SESSION_TBL_LOG.WIDGET_NAME,  SESSION_TBL_LOG.TABLE_BUSNAME) "query"
order by "REPOSITORY_NAME", "START_TIME", "SUBJECT_AREA"