Impact Analysis utility
The Designer is shipped with an Impact Analysis utility that offers the possibility to graphically visualize where a Metadata is used in the current Workspace, what are the sources loading it, and what are its targets.
This can help for instance to find which sources are loading a specific table, and what this table is loading next.
More generally, this allows to see where data comes from, and where it goes.
This article explains how to use the Impact Analysis utility to accomplish this.