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, Senior Oracle Consultant, Burleson Consulting
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
We're using the following string to connect to the Oracle DB Server through the OraOLEDB Driver. We want to read WSID from this string in the ...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.