Informatica help

Informatica help and metadata report query

Deployment Group History

Deployment Group History report

Displays, by group, deployment groups and the dates they were deployed. It also displays the source and target repository names of the deployment group for all deployment dates. This is a primary report in an analytic workflow.


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


select "DEP_GROUP_NAME",
"DESCRIPTION",
"REPOSITORY_NAME",
"CREATED_BY",
case when ("GROUP_TYPE" = 0) then ('Normal') else (case when ("GROUP_TYPE" = 1) then ('Dynamic') else ('') end) end as "Calc_GROUP_TYPE",
"TARGET_REP_NAME",
"USER_NAME",
"DEPLOY_TIME"
from (SELECT  DISTINCT DEPLOYMENT_GROUP.DEP_GROUP_NAME,     DEPLOYMENT_GROUP.GROUP_TYPE as GROUP_TYPE,  DEPLOYMENT_GROUP.CREATED_BY,  DEPLOYMENT_GROUP_DETAIL.DEPLOY_TIME,  DEPLOYMENT_REPOSIT_INFO.REPOSITORY_NAME,  DEPLOYMENT_GROUP_DETAIL.TARGET_REP_NAME,  DEPLOYMENT_GROUP_DETAIL.OBJECT_NAME,  DEPLOYMENT_GROUP_DETAIL.OBJECT_TYPE_NAME,  DEPLOYMENT_GROUP_DETAIL.SRC_VERSION_NUMBER,  DEPLOYMENT_GROUP_DETAIL.TARG_VERSION_NUMBER,  DEPLOYMENT_GROUP_DETAIL.SRC_SUBJECT_AREA,  DEPLOYMENT_GROUP_DETAIL.TARG_SUBJECT_AREA,    DEPLOYMENT_GROUP_DETAIL.IS_SHORTCUT as IS_SHORTCUT,    DEPLOYMENT_GROUP.DESCRIPTION as DESCRIPTION,    DEPLOYMENT_GROUP_DETAIL.USER_NAME    FROM  REP_REPOSIT_INFO DEPLOYMENT_REPOSIT_INFO,  REP_DEPLOY_GROUP DEPLOYMENT_GROUP    LEFT OUTER JOIN REP_DEPLOY_GROUP_DETAIL DEPLOYMENT_GROUP_DETAIL    ON DEPLOYMENT_GROUP.DEP_GROUP_ID = DEPLOYMENT_GROUP_DETAIL.DEP_GROUP_ID  WHERE  (DEPLOYMENT_GROUP.DEP_GROUP_ID <> DEPLOYMENT_REPOSIT_INFO.REPOSITORY_ID)) "query"
order by "DEP_GROUP_NAME"

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