Transactional detail fact table w/complimentary snapshot table. Ho...

Conformed Dimension for Transaction Fact and Accumulating Snapshot Fact Table

I'm working on a new warehouse application for reporting against our IT Project database. I want to create both a transaction fact table and an accumulating snapshot fact table. The project database (source) consists of multiple normalized tables to

Transaction Fact design

hi I am faced with a problem designing a transaction fact in an investment firm. each transaction represents a trade the traders put in (buy,sale etc). The problem I am facing is: the metrics of a transaction change from one day to another day so a

Source for Accumulating Snapshot Fact table

I have a question about accumulating snapshots and I was hoping someone could shed some light on the subject. Does Kimball give any guidance anywhere (books, online, etc.) as to whether one should build the supporting transactional fact tables that

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

Large Fact Table and Maintaining Periodic Snapshot: Practice

I would like some opinions with my approach here. I am trying to replace an overkill lift and load ETL process that basically replicated the entire universe of dataset every period instead of doing just Delta Load. In this delta approach, I have a stage

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

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

Combination of SCD2, partial snowflake, Effective and end dates in fact table

We are creating dataware housing for multitanant based systems for HR module. Requirement ?Able to report on historical data for any given data time. Active employees headcount till given date. (as of that day) Onhire and termination based on perticula

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

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

Black Ops

First off, I went to the COD channel on Youtube. I now regret EVERYTHING I said negative about Black Ops. I saw their recent videos and updates on BO and the game looks purely amazing. Just watch the vids, the WHOLE vids. Also they have a ballistic

Give me some hard NES games to play and I will commentate on them.

I am incredebily bored so I decided that tommorow I will play a bunch of hard NES games then switch to the next game down the list after I rage quit or get bored of the other one. For the sake of time, No RPG's. List: 1.) Battletoads 2.)

Play billiards and win a walk!!!

where: starpaper when: June 27,2009 (saturday) Time: 1pm onwards format: 9 Ball round robin, single knockout race 6 handicapping is possible in order to give equal opportunity to players with different skill sets. entry fee: P 400 loser pays fo

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