Fact/dimension table Setup

fact table as a dimension

Hi I'm presently modeling a data mart and I would like to use a fact table as a dimension for another fact table. Is it something doable and efficient or is there a better way to do that? if yes should i just create a surrogate key and link both

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

NULL Values in Fact Table

In an Accumulating Snapshot that has multiple dates, where we are revisiting the fact rows as additional events occur, should the foreign keys to the date dimension for dates that have not yet occurred be set to NULL or should they point to a

Large Dimension table compared to fact table?

I may be misguided in my attempt to make a dimensional model here, but I will explain the scenario. We provide a value add service in the supply chain business...in this case by depicting a scorecard of the accuracy of vendors' product sizing

fact table as a dimension? Is that bad?

I'm working on my first business process in a dimensional model for a call center. The process we've selected is Quality Assurance; the grain of the fact table is one record for each Quality Category. Another fact we'll be creating is a contact point fact

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

Sparse dimensions, how to handle?

I've purchased the book "The Microsoft Data Warehouse Toolkit" and have reviewed it in order to build out a data warehouse solution I am currently designing. I am stuck in a spot that I don't seem to find any examples of , or am not abl

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

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

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 as a dimension

Hi I'm presently modeling a data mart and I would like to use a fact table as a dimension for another fact table. Is it something doable and efficient or is there a better way to do that? if yes should i just create a surrogate key and link both

Sneak Peek - AOC Breeze

The AOC Breeze is a 8 inch tablet running Google's Android OS. Whilst the price tag might classify the Breeze as a budget segment tablet, its list of features says otherwise. With a USB2.0 port, Micro SDcard reader, 4GB internal memory, and WiFi b/g, this

Lovers Mafia Game Thread

4 Vanilla Townies 2 Mafia Lovers Role PMs:You are a Mafia Lover. You win if two Vanilla Townies are lynched. You may communicate with your partner at any time via this quicktopic: [REDACTED]You are a Vanilla Townie. You win when one Mafia Lover is