character data in a fact table?

Duplicating a field in more than one fact table.

Question about dimensional modeling. Scenario: I have a dimension called: 1. Dim_Application And two fact tables: 1. Fact_ApplicationStatus 2. Fact_ApplicationConsolidation Now the Dim_Application consists all the applications

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

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

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

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

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

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

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

Earthbound Character Rankings!

Totally want discussions since I'm bored. Anywho to discussion's are ahead of us. 1st: You can't deny that Jeff isn't top. The Multi Bottle Rockets is undoubtedly the strongest form of damage in the game. He's also a great Team supporter. The

Which Final Fantasy character are you?

Go to these websites: http://www.ff-fan.com/chartest/ http://www.quibblo.com/quiz/ayLH8Pq/Which-Final-Fantasy-Character-Are-You Answer the quizzes and after that, copy the big HTML codes and past them here so that everyone can see who your character

Kirby's Epic Yarn!

So I got this today! Everybody with a soul enjoys some Kirby every now and then. This si Kirby's first console platformer game since Kirby 64 way back in 2000, I think it was. Time flies, eh? So here is what Sparky thinks of it: First off, Toys R' Us i