Closed. This question does not meet Sta开发者_高级运维ck Overflow guidelines. It is not currently accepting answers.
Is there an expected size of tempDB for a Data Warehouse application. Is 10 gigs excessive? It\'s hit by frequent large queries.
In the old days we used to access the database through stored procedures.They were seen as `the better\' way of managing the data.We keep the data in the database, and any language/platform can access
I\'m developing a datawarehouse to be part of my company\'s enterprise application suite.So I\'ve been learning a lot about DW concepts but the rules engine seems difficult and I can\'t find much info
I am new to OLAP. I understand the table struc开发者_如何学Goture and ETL process. I don\'t understand when data is supposed to be deleted from the fact table.
I\'m looking at building some data w开发者_开发问答arehousing/querying infrastructure, right now on top of Map/Reduce solutions like Hadoop.
Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing
I\'m familiar with the concept of using partitions in Oracle as a technique to pubish incremental additions to tables (in a DW context).
For our reporting application, we have a process that aggregates several databases into a single \'reporting\' database on a nightly basis. The schema of the reporting database is quite different than
I have two t开发者_如何学Pythonables, records are being continuously inserted to these tables from outside source. Lets say these tables are keeping statistics of user interactions. When a user is cli
加载中,请稍侯......