Question

  Asked: May 29 2008   2:27 PM GMT
  Asked by: Mkaukonen


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.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



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.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on DataManagement, Database and Oracle.

Looking for relevant DataManagement Whitepapers? Visit the SearchDataManagement.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register