We\'re thinking about putting up a data warehouse system to load with web access logs that our web servers generate.The idea is to load the data in real-time.
My custom web servers report session information 开发者_如何学编程in the form of a wall clock timestamp (start of session) and the number of wall click seconds the session lasted.
What is the most straightforward approach to producing a data set that can be used in a SQL Server Reporting Services report to display the following:
Folks, We\'re building an ETL process to load mid-size开发者_StackOverflow中文版 dimensional data warehouse using SQL Server 2005 SSIS on 64bit OS. We\'re planning to use SSIS\'s Checksum package to
Our product takes tests of some 350 candidates at the same time. At the end of the test, results for each candidate are moved to a datawarehouse full of indexes on it. For each test there\'s some 400
I need a template to document an SSAS cube. Cube info Single source of data One main Fact table Five direct dimensions
I have read a couple of books on SQL Server 2005 but have not found a proper answer to what I am looking for.
My warehouse datamart data is split across 3 databases on the same server. This is Proof-Of-Concept project with three extracts that were loaded into individual databases.
I\'m developping a distributed solution with a WebSite and a Corporate Application Management. Here is the architecture :
how would you model this in a data warehouse: there are municipalities which are geographical areas, that exist in geographical hierarchies, such a province (i.e. state, e.g. Minnesota), region (e
加载中,请稍侯......