Is there a way to view the 开发者_StackOverflow中文版details (the grain) in an OLAP cube in excel? I know excel can already show the measures that are aggregrated, but the users want to see the detail
I have wrote a ETL process that perform ETL process. The ETL process needs to process more than 100+ million or rows overall for 2 years worth of records.To avoid out of memory issue, we chunk the dat
When modeling a data warehouse, is there any reason we should favor Data Vault over Dimensional modelling? 开发者_JS百科What are the major differences between these two?Dimensional modelling is in my
I am new to BI/Datawarehousing, and after building some easy samples, I have the need to build a more complex structure. My project initially involved product licenses, and I was measuring how many so
I have read that a staging table should be an exact column by column mat开发者_如何学Cch of its target table in the dw. If that is the case, after populating the staging table is it best practice to n
In my data warehouse I got a dimension where each record can have one or several tags. Are there any straight forward ways to model a dimension with different tags?
I have been asked to add a new table to our data warehouse.Currently, we separate our facts into monthly, quarterly, and yearly tables, with time dimensions for each.Each fact record has one time valu
i need to explain the practical problems that might be encountered when transforming their transactional (and other) data from their diverse sources into the Data Warehouse. according to my knowledge
I\'m designing an ELT system for a data warehouse and was wondering what is the most effective while still (in some sense) safe way of extracting the data from the source database.
I got a ton of samples in the following format: <timestamp> <dim1> <dim2> <dim3> 324
加载中,请稍侯......