Question

Data Modeling Tools for relational database & dimensional data mart

Data modeling, Data Model Diagram, Toad Data Modeler, Relational databases, Oracle, Data mart, Oracle Data Mart, Snowflake Schema

I am working with both an Oracle relational database as well as an Oracle data mart, with snowflake schema. Do I need a particular modeling tool to reverse engineer the data mart to produce a data model diagram? Presently I am using Toad Data Modeler to produce a data model for the transaction database.

You don't need any specific tool to do a data mart compared to an OLTP database. Toad will work just fine. Many people including myself prefer to use Visio to do this. This gives you a second option.