TWO FACTS JOINing?

View previous topic View next topic Go down

TWO FACTS JOINing?

Post  SathyJaanu on Wed Nov 18, 2015 3:53 pm

Can two facts table be joined a common dimensional table?

FACT1 ->Dim 1

Fact2--> Dim 1

Fact1--->Dim1--->Fact2

SathyJaanu

Posts : 20
Join date : 2015-10-07

View user profile

Back to top Go down

Re: TWO FACTS JOINing?

Post  ngalemmo on Wed Nov 18, 2015 4:35 pm

Unless you have created specific relationships to support a join (not something you should normally do in a dimensional model) you must assume a M:M relationship between any two fact tables.

To combine two fact tables, the process is a follows:

Summarize each fact along common dimensions (keys or attribute values). Summarization creates a 1:1 relationship between the two summaries.
Join the summarized data by those dimensions.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: TWO FACTS JOINing?

Post  BoxesAndLines on Wed Nov 18, 2015 4:40 pm

Yes, it's called drilling across.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: TWO FACTS JOINing?

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