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!

Subselect in ODI 12c without using Reusable Mappings

Jose VidalSep 13 2016 — edited Sep 15 2016

Hi All,

I have again another instance where I would like to reproduce the code generated by OWB in ODI 12c.

There is a mapping where OWB using three different “data sources”. Two of them are “subselects” within the FROM clause and the third one is just a table.

I can easily generate these “subselects” by using Reusable Mappings but then I have to create three objects to achieve the same thing that can be done by using only one object in OWB.

There is an option to use a Custom SQL statement (CUSTOM_TEMPLATE) within the sources of the “Physical” tab of the mapping but I don’t like this approach because it’s basically hidden code and it would be harder to maintain for other developers.

Is there any other way to avoid Reusable Mappings and CUSTOM_TEMPLATE to reproduce this behaviour?

Thanks,

Jose

This post has been answered by Jose Vidal on Sep 15 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 13 2016
Added on Sep 13 2016
#business-intelligence-applications, #data-integrator, #owb, #system-management-and-integration
3 comments
1,414 views