My Oracle Support Banner

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

Last updated on AUGUST 28, 2020

Applies to:

Oracle Data Integrator on Marketplace - Version 12.2.1.4.200618 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


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