DATE OR DATE KEYS IN FACT TABLES

Updating Periodic Snapshot Fact Tables

What are the best practices for maintaining periodic snapshot fact tables if the atomic data that created them is modified? We have a couple periodic snapshot tables that capture new inventory and new revenue at the end of every month. Sometimes the

How to manage nulls in Fact talble

Hello, I am new with data warehousing. I need some help with following questions 1. should the nulls be left as nulls in fact table or should they be replaced with some number that might never be used like -7 or -1. If they should be replced with -1/-

Loading Fact table

Hi, I have following tables FACT, A_DIM, B_DIM. How do I update relationship between a_key and b_key in the FACT table when new record arrives in TYPE2 a_dim dimension? Below is simple create scrip to illustrate what I mean. create table fact (a_key

Textual values in dimension tables

With much interest I am reading "The Data Warehouse Toolkit", and I stumble upon a design thing that I have done differently in my Data Warehouse design (this is described in the book on page 42). It describes about the dimension table that it

Loading Data Aggregated to Date into Fact Table

I have following source table: Source Table ID App_Version Os_Version Date 9123305 2.5.2.60 Windows NT 5.1 2/15/2009 9123306 2.5.2.60 Windows NT 5.1 2/15/2009 9123307 2.5.2.60 Windows NT

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

Next up date: publication of new administration pane

Hello, We have the pleasure to announce you the imminent publication of our new free forum creation interface ( forumotion.com ) and our new administration panel. The ergonomics and the design of our service were revised in order to make the

Staging Activities

What are the common staging activities that the Kimball method recognizes? Traditionally I have used staging databases to 1) Decouple from the source-to-Data Mart for restartability 2) Consolidate multiple sources and source formats into a single

TATA ELXSI

TATA ELXSI ( www.tataelxsi.com ) About Company Seamlessly integrating precision and ingenuity, Tata Elxsi's abilities stem from our creative leadership in hard-core technology and strength in design. Augmenting these capabilities is our expertis

Who would you say would make a good husband for Samus Aran?

I'm sure we're all aware of how people like to joke that Metroid's Samus Aran is married to Halo's John 117, (Master Chief) but if you had to choose a husband for Samus, who would it be? Rules: 1.) It cannot be You (sorry, guys...) 2.) It can't be

Mid7015 firware update

There is a firmware update on the Coby USA web site. No info on what is in it or how to install.

Celebrity Apprentice 4

If this is a sample of the cast....yikes. Is this their best??? Celebrity Apprentice 4 cast names leak out The Celebrity Apprentice 4 starts filming next week, and several cast members names have been leaked to various