Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI 12c mapping and data lineage

JimmyOTNCOct 16 2018 — edited Oct 16 2018

try to write a query to find out the basic data lineage against the snp_map... tables. Need some help. What I need is:

mapping name, source schema, source table, source column, target schema, target table name, target column and mapping, such as:

load emp info       HR                     EMP               EMP_ID                STG               STG_EMP             EMP_ID             AS IS (or   HR.EMP_ID)

load emp info       HR                     EMP              EMP_SAL             STG               STG_EMP             EMP_SAL          HR.EMP_SAL* (1+ 10%)

load tmp info                                                                                      STG               STG_EMP             UPD_DT             sysdate

Thanks
Comments
Post Details
Added on Oct 16 2018
#business-intelligence-applications, #data-integrator, #system-management-and-integration
2 comments
2,714 views