0

I have to create an Oracle data warehouse so that I can create data cubes on that database, but I don't know how to start. I have an oracle database running as a production database. Using this database I get all my production data and dump that into the data warehouse, so what i do first? like first I create a database on a server and then install a warehouse builder and then create data cubes on that?

James Z
  • 12,209
  • 10
  • 24
  • 44
Khizar Khan
  • 1
  • 1
  • what tool will you be using to deliver the data cubes? I also suggest you first google 'star schema' – Nick.Mc Oct 08 '19 at 12:22
  • @Nick.McDermaid I will use oracle AWM for creating cubes. can I make data cubes on the transactional database? – Khizar Khan Oct 09 '19 at 04:52
  • Did you google "star schema"? You should create a star schema in the database. This is the perfect model for use by cube engines. – Nick.Mc Oct 09 '19 at 13:24
  • @Nick.McDermaid this star schema can I create in transaction database? – Khizar Khan Oct 27 '19 at 05:27
  • Yes. You're getting really mixed up with terminology here. A star schema contains fact and dimension tables. Fact and dimension tables are simply normal database tables but modelled in a certain way. You create a star schema in a database, and it makes it easier to build cubes. – Nick.Mc Oct 27 '19 at 05:45
  • ok @Nick.McDermaid now i am getting closer, now tell me steps which i do first like first i understand star schema and then create cubes? – Khizar Khan Oct 27 '19 at 06:08
  • @Nick.McDermaid and also tell me which tool i use to create start schema and data cubes in the oracle database. – Khizar Khan Oct 27 '19 at 06:23
  • You can create a star schema using SQL Developer. You design the star schema first then you build it in SQL Developer. But to be honest you seem a long way from that. I suggest you install AWM (the tool you already mentioned) and do some investigation. A Data warehouse does not arise from a vacumn. You must have some business requirements right? You can't just build an analytics system with tools, you need to analyse and understand it. – Nick.Mc Oct 27 '19 at 06:31
  • Maybe start here: https://www.youtube.com/watch?v=vJ122Miiavo NOTE: I am linking to youtube videos... anyone can search and find a youtube video – Nick.Mc Oct 27 '19 at 06:32
  • ok @Nick.McDermaid i will do this and let you know my progress. – Khizar Khan Oct 27 '19 at 06:34
  • @Nick.McDermaid yes I have some business requirements and structure of star schema in my mind that will full fill the business requirement, I am confused about how to start things.i just want to do this without creating a data warehouse or a separate database for this, now I have some direction that I can do this also on my transaction database by creating a star schema and then create cube by using AWM or SQL developer right. – Khizar Khan Oct 27 '19 at 06:41
  • You don't technically need an intermediate database. It's just the way it's always done, for good reason. So if you're having difficulty starting I suggest you install AWM and start building cubes directly from your OLTP database. – Nick.Mc Oct 27 '19 at 06:58

0 Answers0