最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

sql - ODI Metadata Repository - Getting Reusable Mappings used by Mappings - Stack Overflow

programmeradmin1浏览0评论

I need to extract from the Oracle Data Integrator Repository the Reusable Mappings used by Mappings. We know there's the SNP_MAPPING table, which contains all Reusable Mappings and Mappings. For example, in SNP_MAPPING, we might have these two rows:

I_MAPPING: 1
NAME: This_is_a_Mapping
[other columns]

I_MAPPING: 2
NAME: This_is_a_ReusableMapping
[other columns]

Where do I find the relationship between the two rows, knowning that "This_is_a_ReusableMapping" is used within "This_is_a_Mapping"?

发布评论

评论列表(0)

  1. 暂无评论