Table of Contents

Search

  1. Preface
  2. Mappings
  3. Parameters
  4. CLAIRE recommendations
  5. Data catalog discovery
  6. Visio templates

Mappings

Mappings

Data catalog discovery example

Data catalog discovery example

You need to create a mapping that reads data from an orders table. You know that the table is in an Oracle database, but you cannot remember the exact table name or which connection the object is associated with.
You open the
Data Catalog
page and enter "tables with order" in the search field. The search returns a list of tables and views that contain “order” in the name or description, tables that have the associated business term "order," and tables that contain columns for which the "order" data domain is inferred or assigned. The search results also show details about each object.
You select the table that you were looking for and add it to a new mapping. You then open the Source transformation in the mapping, click the
Source
tab, and click
Select an object from the inventory
. You select the table from the mapping inventory and click
OK
. The table becomes the source object.