I\'m getting my first exposure to data warehousing, and I’m wondering is it necessary to have foreign key constraints between facts and dimensions. Are开发者_JAVA百科 there any major downsides for no
We currently use SQL Server 2005 Enterprise for our fairly large application, that has its roots in pre SQL Server 7.0.The tables are normalized and designed mainly for the application.The developers
I am new to the data warehousing 开发者_开发百科and was just curious to know if oracle 10g or MySql can be used for multi dimensional data warehouse or we can only use something like Hyperion ?You can
We\'ve been discussing design of a data warehouse strategy within our group for meeting testing, reproducibility, and data syncing requirements.One of the suggested ideas is to adapt a NoSQL approach
Currently I am designing a database for use in our company. We a开发者_运维问答re using SQL Server 2008. The database will hold data gathered from several customers. The goal of the database is to acq
I am a newcomer to data warehouses and have what I hope is an easy question about building a star schema:
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.
I\'m currently building an ETL system to load a data warehouse from a transactional system. The grain of my fact table is the transaction level. In order to ensure I don\'t load duplicate rows I\'ve p
I have a Measure Group, that is partitioned daily.I can process a particular partition, and the XMLA command completes successfully.Furthermore, I have ensure at least one partition is processed for e
Wh开发者_开发技巧at does Delta Extraction mean in regards to Data Warehousing.Only picking up data that have changed since the last run. This saves you the effort of processing data that you\'ve alrea
加载中,请稍侯......