What happens when I mark tables and columns as Not Used?

  • Any mappings to the table or column are deleted.

  • The transformation's status can be Complete without mapping the table or column. Completeness is required for validation and installation.

    Note:

    Columns populated by TMS are never included in calculating completeness even if they are marked Used.

  • Validation checks and custom listings that are dependent on a table or column marked Not Used are disabled. If you later mark the table or column as Used, you must manually reenable the validation checks and custom listings.

  • The table or column is not visible in the Listings pages.