0 Replies Latest reply: Aug 9, 2012 2:34 PM by User313581 RSS

    Star Schema

    User313581
      We currently have a huge OLTP Oracle database and want to develop a warehouse to be used for reporting OLAP purposes. I have been reading about the Star Schema design and had a question about when its appropriate to use. Our reports are basically on-demand. In other words the customer doesnt necessarily run weekly, monthly or quarterly reports. So summarized data wont really be needed in our data marts. Since this is the star schemas strong point, will it still make sense for us to go that route?

      Anyone have experience with this?

      Thank you,