Model available time per day in timesheet data warehouse: fact or dimension or neither?
Hi I am new to data warehousing and related subjects and as a first project I am busy analyzing our timesheet data. I would like some design ideas for the following problem: I need to compare each consultant’s weekly (and monthly and annual) utilization,

Store Business Hours in Time Of Day dimension?
Hello, I am building my first DataWarehouse and I got stuck on how to handle the time of day and my business hours. I am trying to evaluate response times for support cases and I have multiple time zones with different business hours. I only need to

rollup fact table
If creating a roll up fact table would you consider using something other than the surrogate key for your date dimension join? I would not but my colleagues think we should be using month_id for example if we are creating a monthly roll up table from a

Match of the Day 2
I thought I'd leave this until it appeared on iPlayer, but there's little sign of that happening... As a closing item on Sunday's programme they had a montage of moments from the season along with "Open Arms" from the Elboys. I found it

multiple 'fact' tables - daily detail and monthly allocations
I am sure this has been asked but I could not find a direct answer. We have an EDW with a transaction level fact table including pertinent financial detail. For the purposes of this question there are multiple transactions per client, and multiple clients

ADVFN Morning Euro Markets Bulletin - June 30th 2010
By ADVFN.com ADVFN offer FREE streaming stocks and shares data form around the world. SEE London Markets Report : Steady opening for blue chips London has stabilised after the pounding for share prices on both sides of the Atlantic. Anglo-Swedis

One Day Like This - Orchestra
Hey Guys, I am pretty new to this forum, so I have no idea if the answer to this question has been posted elsewhere, if it has I apologise.. I play in a youth string orchestra and I was wondering if anyone had released the string score/sheet music

Fact table with non-numeric measure
I have a transactional fact table containing results of inspections. The results are non-numeric, but do represent a measurement, that is inspection result (like "pass", "fail", "pass with infraction", "failure with

One day like this -instrumental version
Hi - don't know whether any of you lovely people can help me. I want to get hold of a instrumental version of 'one day like this' to use at my wedding. I've found a few kareoke versions online but they're not a patch on the real song. Has anyone come

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

Fact Table Indexing Strategy
Please explain the indexing strategy which is in use in your organisation for fact tables in your current database(oracle, sybase, db2) Specify volume as the indexing strategy may be based upon the volume of data. Is there a well laid out strategy

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 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

Snow Patrol cover 'One Day Like This' live.
Went to see 'An Evening With Snow Patrol' at the Royal Albert Hall last night. They mostly performed reworked versions of their own songs but also did two cover versions; Madonna's 'Ray Of Light' and Elbow's 'One Day Like This'. Gary Lightbody paid tribut

DATE OR DATE KEYS IN FACT TABLES
I've read different opinions about the usage of dates in fact tables. If a date is NEVER used to filter and only reported, what is the purpose of adding it as a date key instead of a plain date type? Aren't we wasting the resources to get to the date