We are about to add a Reporting Data Warehouse to our system. Currently we are using Oracle 10g for our transaction database. Should we put the开发者_如何学Python Reporting Warehouse on physically dif
I have a hierarchy, like an ProductDimension hierarchy.Currently, I query this table using the Nested Sets methodology.I write the usual star-schema joins to get a time-series report of groups of Prod
Background: I have a PostgreSQL (v8.3) database that is heavily optimized for OLTP. I need to extract data from it on a semi real-time basis (some-one is bound to ask what semi real-time means and
I\'m building a data warehouse. Each fact has it\'s timestamp. I need to create reports by day, month, quarter but by hours too. Looking at the examples I see that dates tend to be saved in dimension
I\'ve read a lot about star-schema\'s, about fact/deminsion tables, select statements to quickly report data, however the matter of data entry into a star-schema seems aloof to me.How does one \"theor
I\'m working on a data warehouse and I\'m trying to figure out how to best verify that data from our data cleansing (normalized) database makes it into our data marts correctly.I\'ve done some searche
Consider a grocery store scenario (I\'m making this up) where you h开发者_开发技巧ave FACT records that represent a sale transaction, where the columns of the Fact table include
Please tell the concept of AbInitio recovery file. When the Abinitio graph fails in execution which cases shou开发者_如何学Gold we rollback the recovery file and in which cases we shouldnt rollbac
So I\'m currently working on a project that involves the collection and storing of some huge datasets (as far as what I\'m used to working with). The data essentially consists of meta information, and
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.
加载中,请稍侯......