This discussion is archived
0 Replies Latest reply: Aug 9, 2012 12:34 PM by user313581 RSS

Star Schema

user313581 Newbie
Currently Being Moderated
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,

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points