Q

Using star schemas for warehousing financial data

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.  

This was last published in September 2004

Dig Deeper on Oracle data warehousing

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close