Regarding Factless Fact Tables

Looking for advise on loading keys into factless fact tables

Please consider the following options and recommend an approach. Thanks in advance. Option 1 PERSON_KEY DEGREE_KEY LANGUAGES_SPOKEN_KEY ROLE_TITLE_KEY P1 D1 L1 R1 P1 D2 L2 R2 P1 D1 L3 R3 P1 D2 L3 R4 Option

Building aggregate fact tables from staging

Hi, Is it acceptable to create an aggregate fact table from the staging tables after you have cleaned out the data in staging? I know usually you're supposed to create aggregate fact tables from the fact/dimension tables, however can it be done straigh

Joining Factless Fact tables

I am new to BI/Warehousing but have been asked to develop a better reporting system for our software. I am designing a warehouse and seem to have a lot of factless fact tables. There are also many situations where these "fact" tables should be

Factless Sales table

Hi, I was wondering if there is anything wrong with having a factless sales table? Basically all I am required to do is to count up the total number of sales that occurred each month grouped by product type. So basically all I have in my fact table

Combining Factless Facts and Bridges - sensible or not?

We are working in a MS SQL Server 2005 environment using SSIS to populate our DW DB and SSAS to build our OLAP database from that DW DB. It is not a huge database in the scheme of things - 28 million payments, 6 million customers, 2 million membership

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

Dimensional Model Vs Views as Structure for BOBJ Universe

I have a fairly complex data mart (multiple fact tables: 5 at the moment and several more coming; 4 shared dimensions across the 5 facts, 26 total dimensions and several bridge tables). I used standard best practices for building the Business Objects

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

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

Dimension with two hierarchies

I need to design a dimension with two hierarchies 1. Location -> Building -> Room -> Cabin 2. Location ->Building I need the hierarchy 1 to be referenced in one FACT table and hierarchy 2 in other FACT. But my ETL tool allows only the dimension ke

Bridge table for patient diagnosis

Hi ngalemmo or fourm members, Can I get advice on how to create a bridge table for patient diagnosis? To keep it simple, I have a patient, facilities, and doctor dimensions and one fact table. For a specific patient, I need to show all diagnosis in a

Volume and Weight in Same Fact Table

Is it appropriate to include two facts that are not of the same type? In my example, I may need to have both Volume (Gallons) and Weight (Pounds) in the same fact table. I am building a DW around products that we recycle, these products can be Oil or