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 first published in September 2004

Dig deeper on Oracle data warehousing

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close