Is there a place I can view or do开发者_运维技巧wnload the geography dimension for data warehousing purposes?if not how do I go about creating one?
I\'m building a data warehouse based on NFL statistics for educational purposes as I learn this paradigm - I have the following modelling problem
Star schema consists of dimension and fact tables. Fact tables contain foreign keys for each dimension and in additio开发者_如何学JAVAn to that, it contains \"measures\". What exactly comprises of th
Data warehousing seems to be a big trend these days, and is very interesting to me. I\'m trying to acquaint myself with its concepts, and am having a problem \"seeing the forest through the trees\" be
I am developing a data warehouse + a data cube for a certain client using Microsoft technologies (SSIS, SSAS and SSRS). I have almost finished doing the data warehouse. I have created a data cube in S
I\'m part of a team looking to move from our relational data warehouse to a SSAS cube.With our current setup we have an \"EmployeeCache\" table (basically a fact) which is a mapping from each of our e
I have the following database db: exam_2011 tables: score_01, score_02, score_0开发者_如何学Go3.....score_12
In my cube there are certain measures which are non-additive, however I can compute a value for every drill down level. Unfortunately the computation is too complex for it to be done in in Analysis Se
SAS programmers at my company work with researchers to analyze data stored in a number of text files around 1Tb in size.The resulting SAS processes can take days to run.Whenever the researchers want t
I am new to postgres and DW, and I have to design a DATE Dimension as given in book. I saw many places on the web and I did not succeed so far, can some explain how to populate fields like \'Fiscal We
加载中,请稍侯......