Factless Sales table

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

Advice on factless table use

I have a situation where i have modeled a process relating to invoicing such that there is a fact table of invoice line items and some dimensions such as date and recipient of the item to name a couple. The situation i am encountering however i

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

Fact table design: Sales Transaction with multiple Discount rows

Hi, I am designing a Sales DW where we can have multiple discounts on a given transaction line. I created a SalesTransaction (ST) fact table and a SalesDiscount (SD) fact table. In the current design the ST table has its own key that is a bigint

SET1/Q.2 a. Differentiate between sales quotas and sales territories.

Q.2 a. Differentiate between sales quotas and sales territories. b. Briefly explain the functions of logistics management.

Global and China Rechargeable Lithium Battery Industry Brief Report

There are only ten rechargeable lithium battery cell manufacturers all over the world. A large proportion of Japanese manufacturers are engaged in the production of laptop battery cells, while South Korean and Chinese manufacturers mainly focus on

PS3 to outsell Xbox 360, Wii in lifetime sales, says analyst

A research firm this week said Sony Corp.’s Playstation 3 will outsell Microsoft Corp.’s Xbox 360 and Nintendo Co.’s Wii in lifetime sales. The Strategy Analytics Connected Home Devices firm this week predicted the PS3 will hold lifetime sales of 127

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

SALES CONSULTANT – ATTRACTIVE SALARY HIGH COMMISSION

Catch Mobile Media is CELCOM Authorised Business Partner. To complement our expansion plans, we are inviting energetic and aspiring Sales Ambassadors who looks for HIGH INCOME to apply for the position SALES CONSULTANTS (10 vacancies

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

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

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