HI, HI, Say, I want to create a data mart for sales Dimension: region,products Degenerate dimension: Order Number Measures: price,quantity Qyery: cross product A region B show order numbers where total quantity sold is more than 100000 How to achive this Oracle(11g) AWM or any other tool? How can I tag dimension as degenerate and [...]
Answer Question | March 19, 2009 7:47 AM
OLAP cube, Online Analytical Processing, Oracle 11g, Oracle Analytic Workspace Manager, Oracle AWM, Oracle Data Mart, Oracle OLAP
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