Search This Blog

Thursday, 30 April 2015

Informatica ETL data Lineage SQL Query






SELECT DISTINCT

C.SUBJECT_AREA FOLDER_NAME,
C.MAPPING_NAME MAPPING_NAME,
C.SESSION_NAME SESSION_NAME,
E.READER_WRITER_TYPE,
E.INSTANCE_NAME,
E.CNX_NAME,

CASE
WHEN E.WIDGET_TYPE = 2
THEN 'TARGET CONNECTION'
ELSE
CASE
WHEN E.WIDGET_TYPE IN (1, 3, 56, 45, 55, 84)
THEN
'SOURCE CONNECTION'
ELSE
NULL
END
END CNX_TYPE

FROM INFA_REPO.REP_VERSION_PROPS A,
     INFA_REPO.REP_USERS B,
     INFA_REPO.REP_LOAD_SESSIONS C,
     INFA_REPO.REP_REPOSIT_INFO D,
     INFA_REPO.REP_SESS_WIDGET_CNXS E

WHERE ( A.USER_ID = B.USER_ID
AND C.SESSION_ID <> D.REPOSITORY_ID
AND C.SESSION_ID = A.OBJECT_ID
AND C.SUBJECT_ID = A.SUBJECT_ID
AND A.OBJECT_TYPE = 68
AND C.SESSION_ID = E.SESSION_ID
AND C.SESSION_VERSION_NUMBER =
E.SESSION_VERSION_NUMBER)

5 comments:

  1. I get a lot of great information from this blog. Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing.
    informatica training in hyderabad

    ReplyDelete
  2. informatica etl data lineafe sql nice posts..


    informatica online training




    ReplyDelete
  3. OBI Apps, OBIEE, Data Warehouse, Informatica, DAC,PL/SQL nice posrts..
    informatica training

    ReplyDelete
  4. Useful Information :

    Looking for the Best [url= Digital Marketing in Vijayawada ][/url] , We provide training on live projects, internship, Flexible Classes, Free Demo @ praiseads.com

    ReplyDelete