Monster dimension, joining fact tables

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

Differing grain dimension tables with the same transactional fact

Is it appropriate to relate different grain dimension tables (aggregate dimensions) with the same transactional fact table?

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

Joining fact tables

I have a order fact table. I have a call fact table. For each order, there is a call associated with it. Would I have the call id on the order fact and to join the 2 facts?

Joining Type II Dimension Hierarchy directly to Fact versus through a Dimension table

Given I have 3 tables, Workforce Event Fact, Department Dimension (Type II SCD), and a Department Hierarchy (Type II SCD), and assuming the DEPTIDs in the Department Dimension table are reflected in a BASEDEPTID field in the Dept Dimension hierarchy table

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.

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

Overlapping Dates in a dimension

Hi, I am wondering if someone could advise me on how to deal with this design problem. I have a promotion dimension keyed to a sales fact table. Initially, we thought that only one promotion could be active at one time for a sale, but it is actually th

My monster stash!

I know it's ridiculous, but it's so hard to choose which ones to sell!!

Reducing permissions on Firefox extensions

There has been a topic brought up elsewhere regarding some of Firefox' add-ons occasionally "behaving badly" with a link here. I was curious so I checked under the security tab of the three add-ons I use (NoScript, Cookie Monster & LastPass)

TeaLeaf Graphics - former testjal

TeaLeaf Graphics The official testing site for Jalokim's evil CSS experiments that is now a real forum testjalCSS TestjalCSS pushes the limits of forumotion to its maximum. The site does not function like regular forums ... its not intended to be