Using star schemas for warehousing financial data
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?
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.
This was first published in September 2004