|
|
Browse by Tags
-
Join Two fact tables that has different grain
I have two fact tables that share the same dimension (consumer) but have different grains .. Fact A: Consumer_key, Episode_key, Episode_Begin_date_key,assessment_key Fact B: Consumer_key, Episode_key, Service_begin_date_key, Sum_of_Cost There is 1:M relationshiop between Fact A and Fact B... IS it a... -
Data warehouse Fact tables' primary keys in stage area needed?
I can across a data warehouse where the stage area's fact tables don't have primary keys. Is it best practice to have and leave them enabled? I know its often good and speeds things up to temporarily drop the bitmap indices during stage fact table loads. But what about their PRIMARY keys? Can... -
Create Fact Table: Best Strategy
I've a FACT table having table size 1280mb, currently 4.5 million records, now we are in need to populate data into this table which is for different application. most of the columns in the new data is VARCHAR(250). So my question is, is it feasible to add the new records into the same FACT Table... -
Problem: Fact Table in Datawarehousing
What is a fact table in datawarehousing? It seems relatively simple to comprehend, but I can't seem to get its logic, besides the obvious 'getting facts from tables.' Thanks! -
Problem: Data Warehouse Design, Fact table with 40 attributes
I am designing a data warehouse for a telecoms company. I have read several books and articles on data warehousing including Kimballs book on Dimensional Modelling and come up with a draft design for one of the core processes. My design has 13 Dimensions which according to kimball is perfectly legal... -
Problem: Data warehouse design, fact to dimention row count ratio
We are working on a data warehouse project for one of our customers. We are now towards the end of the project and have real data going into the warehouse. The database has 13 dimensions and a fact table with 62 attributes. Currently the fact table has 7 million records in it and most of the dimensions...
Page 1 of 1 (6 items)