Header Level Dimension for a Fact Table

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

One Fact table having records at different granularity level

Hello, My question is just validation for an approach that we followed for one of our client requirements. Based on the requirement the FACT table should be constrcuted by the records from 2 Source table A and B. The structure of the table is as

Multi level grainulity in Fact table

Hi , I have strange scenario . The fact table needs to be loaded in different Multi Level Grainluity ,this typical scenario was handled in ETL with complex coding. Advantages of so, 1) The report was directly taken from single table and had no

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

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

TEMPAT LES INGGRIS

Dear all, Ceritanya ane kan baru resign ni dari kantor yang lama, nah skrng untuk ngisi waktu kosong rencananya ane mau les bahasa inggris lagi biar tambah casciscus, Kira-kira sesepuh-sesepuh disini punya saran mengenai tempat les inggris yang

Battery Usage / Charging observations

The battery charging and battery usage seem to puzzle me. Today under controlled environment, I had the unit in operation. Charger attached. Waited until the Icon shows full Green, and battery state (under "spare parts") showed 100% AND fully

brightness adjustment bug

My android 1.6 flytouch has this terrible thing where if you want to change brightness from the default 100% it will go dark-black. As you can't see anything anymore you have two options from there: either you have the terrible luck to remember where to