Primary Key of Dimension and Fact Tables

fact primary key

Hi My data warehouse will have CONTRIBUTIONS fact table which is sourced from a OLTP General Ledger Table. All transactions from the GL table will be put in a ODS staging table (GL_Stage). The GL table primary key consists of 9 fields (transaction

Relationship between Fact and Dimension Table - Identifying or non-identifying?

Can the relationship between a dimension table and fact table be identifying as well as non-identfying?

Primary Key of Fact Table

When designing a fact table, is it best practice to make a composite primary key out of all the foreign keys? Thanks, Kurt V

Joining two Fact tables???

I am having trouble joining two fact tables. I have read the different topics and see that the bridge table would be my logical option. The subject I have is Orders. I can place an Order which may contain many items...as well as, the items can be a par

is it ok to join two fact tables on a degenerate dimension?

The title question is kind of rhetorical because I didn't actually think it was a common practice but I was hoping someone could offer an alternative . Let's say I have a fact_service_provided table where each row describes a service that the business

2 fact at different granuality demanding different level of a dimension hierarchy.

Hi, Here is what i am trying to design. There is a transaction level fact table say Fact1.. One of the dimensions for this fact table is Dim1, which has hierarchy as L1>L1>R1.. leaf to root. The Leaf node (L1) of the dimension is Foreign key in the

Wide and large Dimension or Survey Factless Fact Table

Hi I would like some advice on this particular point. We receive responses to surveys containing hundreds of questions. Those surveys are submitted many times to about ten thousands people we follow. Their answers could change in time. Usually the

Can a fact table be used as a source for populating another fact table

Scenario: There are two source tables : 1. SRC_INV_HDR (1 million rows in a year) 2. SRC_INV_DISCREPANCIES (1lac rows in a year) Landing tables in ODS : DWI_INV_HDR DWI_DISCREPANCIES Two fact tables : 1. DWB_Invoice_hdr 2.

Dimensional modeling on HospitalStay

a different question on The Data Warehouse Toolkit, 2nd Ed. The complete guide to Dimensional Modeling. In Chapter 13 page 265 "In a hospital stay situation, however, the diagnosis group probably should be unique to the patient because it is

Newbie - designing data warehouse for cube

Hi, I have been asked to design a data warehouse that is to be populated by ETL SSISs, then i must design a cube from this data warehouse which a Sharepoint site will point to. My place of work is a statistics gathering organization and the data on the

10 Random Unknown Facts

Lets all get to know each other a little better! Write ten facts about yourself that others probably don't know, and lets get to know the person BEHIND the YouTube name! 1. Im very insecure about myself in real life. Whenever I appear confident it is

eLocity Accessories

Over at XDA Developers posters were discussing what case they were using for their eLocity A7s. One of the cases mentioned is on eBay. It is less than eight dollars. I figured I would try it out. The poster who has it reported that you have to move

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