Fact 1:1 relationship with dimension

View previous topic View next topic Go down

Fact 1:1 relationship with dimension

Post  vee_jess on Mon Nov 10, 2014 10:37 am





Hello,

The above is a dimensional model I am working on based on the scenario. I have few questions and will appreciate if someone can help.

1. DimConsignment and FactConsignment will have the same number of records. Not sure if itís correct to have a fact and a dimension table with the same number of records! If not, whatís the best way to model this? There is also similar relationship between FactParcel and DimParcel.
2. When a factless fact table shares a 1-1 relationship to a dimension table, is it worth having that fact table? Example above would be the FactManifest and DimManifest.
3. Is there anything you would change in the above model to make it better?

vee_jess

Posts : 7
Join date : 2014-10-27

View user profile

Back to top Go down

Re: Fact 1:1 relationship with dimension

Post  ngalemmo on Mon Nov 10, 2014 1:30 pm

What are the attributes of DIM_CONSIGNMENT?

The basic technique is to reduce the contents of the consignment dimension to multiple smaller dimensions and reference those dimensions in the fact. The consignment is reduced to a degenerate dimension (consignment ID).
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Fact 1:1 relationship with dimension

Post  vee_jess on Mon Nov 10, 2014 5:00 pm

In the current OLTP system the consignment table is the main table and it contains lots of fields. I have tried to separate those fields into their own dimensions and also created a FactConsignment table but there some that, i believe need to be in the DimConsignment table. These are
ConsignmentCode,
consignmentWeight,

CreatedDateTime,
ProcessedDateTime,
DespatchDateTim,
StartPostcoe,
EndPostcode,
OrderDate
OrderNumber,
Etc

vee_jess

Posts : 7
Join date : 2014-10-27

View user profile

Back to top Go down

Re: Fact 1:1 relationship with dimension

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum