Is It Possible to Create a Join Manually Through Typing in the Join Properties in ODI ? (Doc ID 2704627.1)

Last updated on JULY 20, 2024

Applies to:

Goal

When creating a mapping and bringing in datasets then doing a join between tables, is it possible to enable the ability to update and edit all, not just some, of the various columns in the Join Properties (such as name, description, derived, etc)? 

Looking to be able to manually type in what is wanted and needed and to be able to add another join through the Join Properties where you just tell it the columns, join, etc... by updating those various properties mentioned above instead of having to click and drag columns onto each other to create the join and so on.

Likewise, looking for the ability to create, edit and duplicate Filters and Lookups in the properties area instead of clicking/dragging.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.