Advice on factless table use

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

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

DatawareHouse modeling (factless table)

Hi everyone ! (To begin, I want to apologize for the bad english i'm gone use cause im french canadian) system i'm using : Sql Server 2005 Ent SSAS 2005 (For cube) SSIS 2005 (For ETL) I'm in the process of building a datawarehouse for the

Regarding Factless Fact Tables

Some time ago I was asked to build the BI platform for a road safety organization. The warehouse was built of three primary fact tables, each with a collection of associated dimensions. I am now trying to branch out into ETL and Warehouse design, and from

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

~* Buddha's Advice *~

Buddha's Advice to Calm a Disturbed Mind Once Buddha was walking from one town to another town with a few of his followers.. This was in the initial days. While they were traveling, they happened to pass a lake. They stopped there and Buddha told

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

Need some advice...

Hi, I got onto a Forumotion site lastnight and it looked good and I was wondering whether it was free, so I scrolled to the bottom and noticed that it was (because of the 'make a free forum')... anyway, I was wondering what sort of things are allowed?

SET1/Q.3 How will you advice a retailer regarding different aspects

Q.3 How will you advice a retailer regarding different aspects considered in store layout and store design? Do you think store layout and store design will help in gaining more customers?

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

How to become a soccer player?

I LOVE soccer and I want to pursue my dream of being a professional or possibly national soccer player. I've been playing soccer for 5 years and I think soccer is my thing. I'm planning to play soccer in university team. Can I become a

The Night will Always Win

Okay then - this is my favourite track on the album (at the moment!). They do seem to have a real tear jerker on every album - SBAW, Switching Off, Great Expectations, Friend of Ours and this one on BARB. The emotion Guy put into singing this is

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