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. In the Additional Mapping Information pane, click the Source Extract SQL tab.

    2. The Source Extract SQL tab appears.

  2. click .
  3. Enter SQL Query and SQL Query Description.

    4. For example:

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

    5. The Source Extract SQL is updated.