data-warehouse

相关标签：javascript jquery android 多少钱 iPhone

Geography/Location dimension table for datawarehousing

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?[详细]

2023-04-12 09:12 分类：问答
Star schema modeling - many-to-many

I\'m building a data warehouse based on NFL statistics for educational purposes as I learn this paradigm - I have the following modelling problem[详细]

2023-04-09 17:12 分类：问答
What is exactly a measure in star schema in data warehouse design?

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[详细]

2023-04-09 11:02 分类：问答
Practical Implementation for Data Warehouse

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[详细]

2023-04-09 08:40 分类：问答
How to make my SSAS cube production ready

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[详细]

2023-04-09 05:46 分类：问答
Dimensional Level Security / Per User Data Security in SSAS Cube?

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[详细]

2023-04-08 00:11 分类：问答
Mysql data warehouse SQL Query Help please

I have the following database db: exam_2011 tables: score_01, score_02, score_0开发者_如何学Go3.....score_12[详细]

2023-04-07 21:20 分类：问答
How to transparently show non-additive measures in Analysis Services as if they were additive

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[详细]

2023-04-04 22:55 分类：问答
Tips/links/books for designing a very large, low-granularity database?

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[详细]

2023-04-01 08:35 分类：问答
Postgres : creating DATE Dimension as per Ralph Kimball

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[详细]

2023-03-29 07:40 分类：问答