Skip to main content Skip to complementary content

Defining a query mapping

Before you begin

  • You have been assigned an object role with the Metadata Editing capability.
  • You have already created the query mapping.

Procedure

  1. Click the name of the query mapping to open the Mapping Editor tab.
  2. Click Add source to select source table(s).
    You can use filters to narrow down the choices from the list.
  3. Specify as many source tables as needed.
  4. In the Columns tab, click the Detect Links magic wand to automatically match tables and columns.
    You can also drag a specific source column to target column to map all the columns manually.
  5. In the Joins tab, click the Detect Joins magic wand to automatically define joins for the source tables.
  6. Save your changes.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here