ODI Query 썸네일형 리스트형 [ODI Repository] Search Interface Description /*Created by Cheon.jhCreeted on 2012.05.25ODI Version. 11.1.1.6Using on showing the description of all Interface. */ SELECT P.TABLE_NAME, '/* Description Job Path: '||F.PROJECT_NAME|| ' - ' || F.FOLDER_PATH|| ' Interface Name: ' || P.POP_NAME|| ' Source Table: ' || LISTAGG(S.LSCHEMA_NAME||'.'||S.TABLE_NAME ,', ') WITHIN GROUP ( ORDER BY S.TAB_ORD) || ' Target Table: ' || P.LSCHEMA_NAME||'.'||P.T.. 더보기 이전 1 다음