0 Replies Latest reply on Aug 9, 2012 7:34 PM by User313581

    Star Schema

      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,