Data Modeling Tools for relational database & dimensional 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.

Answer Question   |  May 31, 2008  2:27 PM
Data mart, Data Model Diagram, Data modeling, Oracle, Oracle Data Mart, Relational databases, Snowflake Schema, Toad Data Modeler

datamart & datawarehouse
What do you mean by DATAMART & DATAWAREHOUSE & what is the difference betwen two??

Answer Question   |  July 31, 2008  7:06 AM
Data mart, Data warehouse, Database Management Systems