Informatica help

Informatica help and metadata report query

Connection Usage Details

Connection Usage Details

Displays sessions associated with a particular connection by repository by folder. This report is the first node in the analytic workflow associated with the Connection Usage primary report.


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


SELECT "SUBJECT_AREA",
"WIDGET_TYPE",
"READER_WRITER_TYPE",
"REPOSITORY_NAME",
"SESSION_NAME",
"WIDGET_INSTANCE_ID",
"SESSION_INSTANCE_NAME",
"CNX_NAME",
"WORKFLOW_NAME"
FROM ( SELECT SESSION_REPOSIT_INFO.REPOSITORY_NAME,
ALL_SESSIONS.SUBJECT_AREA,
SESSION_LOG.WORKFLOW_NAME,
ALL_SESSIONS.SESSION_NAME,
SESSION_LOG.SESSION_INSTANCE_NAME,
SESSION_ALL_CNXS.CNX_NAME,
SESSION_ALL_CNXS.READER_WRITER_TYPE,
CASE
WHEN SESSION_ALL_CNXS.WIDGET_TYPE = 2
THEN
'Target Connection'
ELSE
CASE
WHEN SESSION_ALL_CNXS.WIDGET_TYPE IN (1,
3,
56,
45,
55,
84)
THEN
'Source Connection'
ELSE
NULL
END
END
AS WIDGET_TYPE,
(COUNT (SESSION_ALL_CNXS.WIDGET_INSTANCE_ID))
AS WIDGET_INSTANCE_ID
FROM REP_LOAD_SESSIONS ALL_SESSIONS,
REP_SESS_WIDGET_CNXS SESSION_ALL_CNXS,
REP_REPOSIT_INFO SESSION_REPOSIT_INFO,
REP_SESS_LOG SESSION_LOG
WHERE ( ALL_SESSIONS.SESSION_ID = SESSION_ALL_CNXS.SESSION_ID
AND ALL_SESSIONS.SESSION_VERSION_NUMBER =
SESSION_ALL_CNXS.SESSION_VERSION_NUMBER
AND ALL_SESSIONS.SESSION_ID <>
SESSION_REPOSIT_INFO.REPOSITORY_ID
AND ALL_SESSIONS.SESSION_ID = SESSION_LOG.SESSION_ID
AND ALL_SESSIONS.SESSION_VERSION_NUMBER =
SESSION_LOG.TASK_VERSION_NUMBER)
GROUP BY SESSION_REPOSIT_INFO.REPOSITORY_NAME,
ALL_SESSIONS.SUBJECT_AREA,
SESSION_LOG.WORKFLOW_NAME,
ALL_SESSIONS.SESSION_NAME,
SESSION_LOG.SESSION_INSTANCE_NAME,
SESSION_ALL_CNXS.CNX_NAME,
SESSION_ALL_CNXS.READER_WRITER_TYPE,
CASE
WHEN SESSION_ALL_CNXS.WIDGET_TYPE = 2
THEN
'Target Connection'
ELSE
CASE
WHEN SESSION_ALL_CNXS.WIDGET_TYPE IN (1,
3,
56,
45,
55,
84)
THEN
'Source Connection'
ELSE
NULL
END
END) "query"
ORDER BY "REPOSITORY_NAME", "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