Can you provide a sample database query or any way that can be used to extract specific Attributes from the Mart across all models?
The mart data is mostly encrypted so it is not possible to query it and find, for example the Attribute and which Entity and Model and Library it exists in. However, Report Designer (Tools | Report Designer) has a built-in report that will do that for you.
Please launch erwin DM and connect to the Mart. Open the Report Designer, and choose File | Open Pinned Reports. In the Report Category choose Mart Model Reports and run the report Attribute by Name.
Run the report and check on which Models to report upon and also type the Attribute name.
You can also use the same method to run other reports as available in the Pinned Reports.