We are decommissioning a source step by step and during this we run into the need to easily identify at business unit table (or view) level whether it is in use in the DWH.
When a table or view is not used anymore we can start removing it from the BU.
For this it would be really handy if there was an easy visual cue (e.g. lighter font color) to show that an object is not used as a source for data movements.
There are several alternate solutions that could cover this requirement, which I will post as separate suggestions.
a. Option to do impact analysis at table level
b. Option the flag a table/view or field as "deprecated" after which it generates warnings wherever it's used.