Updating Source Extract SQL

You can keep a record of multiple source extract SQL and its description. You can also update it as per your requirements.

To update source extract SQL, follow these steps:

  1. Go to Application Menu > Data Catalog > Mapping Manager.
  2. Under the Workspace Mappings pane, click the required map.

    3. At the bottom of the central pane, you can locate the Additional Mapping Information pane.

  3. Expand the Additional Mapping Information pane.
  4. Click the Source Extract SQL tab.

    5. The following page appears.

  5. click .
  6. Enter SQL Query and SQL Query Description.

    7. For example:

    • SQL Query - Select * from dbo.RM_Resource
    • SQL Query Description - The query extracts the data from dbo.RM_Resource table.
  7. Click .

    8. The Source Extract SQL is updated.