Informatica help

Informatica help and metadata report query

Target Table Load Analysis(Last Month)

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"

Leave a Reply

Your email address will not be published.Email address is required.

Sponsored Content


Canon EOS 5D Mark IV Full Frame Digital SLR Camera Body


Canon EF 24-70mm f/2.8L II USM Standard Zoom Lens

GoPro HERO5 Black

Canon EF 100-400mm f/4.5-5.6L IS II USM Lens

Firefield FF16001 NVRS 3x 42mm Gen 1 Night Vision Riflescope, Black

Visitors


Quantcast