Star schemas are great for generalized data warehouse schemes, but what if you want to warehouse financial data and preserve the account relationships betweend GL, AP, AR, INVENTORY and the like? Does the star schema have to be abandoned in this case? Can it be adapted?
I have seen warehouses do this kind of thing, so yes, it can be done. You have to decide how you will be using the data in the warehouse; you have to rethink the relations, since a data warehouse is not just a bigger version of your OLTP system. I suggest looking at a few books on data warehouse design and theory before undertaking this conversion.
Dig Deeper on Oracle data warehousing
Related Q&A from Mike Ault
How to find the definition or structure of a dropped table? I know the table's name but I don't know the columns and datatypes. It no longer exists. Continue Reading
I am trying to remove carriage returns at the end of clob fields in SQL*Plus. This just nulls out the field in the table. What do I need to change to... Continue Reading
I'm having a problem with dynamic SQL, specifically getting my incoming parameter into the SQL statement. I am using Oracle 9i and this procedure ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.