1
  • Oracle OLAP degenerate dimension

    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...

    VinayOLAP30 pointsBadges:
  • 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...

    Mkaukonen5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following