I'm sorry to disappoint you but there is not one simple correct answer to your question.
A lot is depending on the structure within your repository (or repositories) and on the table which you are referring to.
And another important thing is how structured is the way developers have been working.
Is it built in PowerCenter or are you using the Developer client?
Furthermore please don't forget that there are SQL transformations and SQL overrides in LKP and SQ transformations.
SQL Transformations can not only have SQL statements wihin them, the SQL transformations can also execute queries which are provided by a String port. And these strings usually are provided by an EXP or AGG, and that means that you have to examine those EXPs or AGGs as well.
Also there could be Target Update Overrides in relational targets, and these statements MAY refer to utterly other tables than the ones this target definition is associated with. This approach is used for example in Test Data Management.
1 of 1 people found this helpful
You can try using the tool MetaQuery to fetch some of the information, and/or use MX views.
The MetaQuery tools is a free download, available on the ftp site at /updates/MetaQuery.
The MX views are documented in the Repository guide.
These might help.
We have a tool that could help your requirement to check the objects as per the requirements.
Please download the Metaquery from the below link and connect the repository and check if that could help your requirements.