You can revert the target table to a non-source mapping object if you delete its associated source mapping objects. If only a single source mapping object is left, right clicking the remaining source mapping object provides the option Revert to Non-Source Mapping Object.
Note
Deleting the target table, deletes all its source mapping objects, including its associated meta data.
