Data Modeling Tools for relational database & dimensional data mart
Home > IT Answers > Oracle > Data Modeling Tools for relational database &...
Mkaukonen
5 pts.
0
Q:
Data Modeling Tools for relational database & dimensional data mart
Oracle, Relational databases, Data modeling, Data mart, Toad Data Modeler, Data Model Diagram, Snowflake Schema, Oracle Data Mart
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.
ASKED: May 29 2008  2:27 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46810 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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.
Last Answered: May 31 2008  9:41 PM GMT by Mrdenny   46810 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0