One Fact table having records at different granularity level

Granularity - One Fact Table or Two

I am warehousing data from a distribution system. The distribution system allows scheduling orders and it has a number of tables that store the delivery (ticket) information. The order / schedule tables look something like this: Order Header >

Fact Table Grain at a Sub-Atomic Level

I'm thumbing through the Design Tips and would love to find some thought given to the statement made in The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (pg 34): "Preferably you should develop dimensional models for the most

Multi level grainulity in Fact table

Hi , I have strange scenario . The fact table needs to be loaded in different Multi Level Grainluity ,this typical scenario was handled in ETL with complex coding. Advantages of so, 1) The report was directly taken from single table and had no

Techniques for Updating existing fact records

I have certain cases where I need to adjust the data in the fact tables due to late arrivers etc... I wanted to get peoples opinion on what techniques work best when you have to do updates to Fact rows i.e. overwrite, adjust but keep audit

Fact table structure

I am pretty knew to the matter and need some guidance to the below. I have been of the view that facts shouldn't contain any descriptive information. But, pretty recently i switched companies and found that we have a scenario where facts in the area had

Transactional detail fact table w/complimentary snapshot table. How do the two play together?

Take a detail daily banking transaction table with standard credit and debit level transactions. I want to build the accompanying snapshot that would present the higher level rollups of these lower transactions: There are about 250 daily transaction

Fact table with multiple date ?

Hi, I am modling a fact table for prisoners inscription in order to track historical changes. An admission is the hole stay comprise of one or many inscriptions usually separated by transferts between institutions. In the transactionnal system, it

Questionnaire for medical record entries

Good afternoon, I am currently working on a data warehouse in the health care sector and I currently facing this problem: The aim of this warehouse is to have an overview of a cancer therapy. So, I have created the following fact table

Montly Snapshot views with transactional Fact table w/SCD2

I am a new at working with Dimensional Database design. I am struggling with something that probley is real easy to do, but just can't find documentation that will explain it. I want to create a monthly snapshot view of my transactional Fact table with

Audit Dimension Help

Hello all. I'm at the stage now where im building the audit dimension for my warehouse. I am having a little trouble figuring out a few things though. How do you aggregate the data from the error event fact table into the audit dimension? Some records

100 reasons why Madeleine was not abducted

http://blogs.news.sky.com/discussions/show.html?plckForumPage=ForumDiscussion&plckDiscussionId=Cat:746f9309-1bb1-4b07-ad11-647f5ba16800Forum:4237bf3e-0948-444d-a452-46289a2fd1f7Discussion:53085ce6-d0e9-4517-9607-a2eb2b4b9b84 class=Discussion_PostTi

Migraines and thyroid

An interesting article on the role of an even slightly underperforming thyroid on migraines. http://headaches.about.com/od/comorbidconditions/a/thyroid_comorb.htm Has anyone here had a doctor investigate their thyroid? I've never had anyone bring

brightness adjustment bug

My android 1.6 flytouch has this terrible thing where if you want to change brightness from the default 100% it will go dark-black. As you can't see anything anymore you have two options from there: either you have the terrible luck to remember where to