Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

TWO FACTS JOINing?

3 posters

Go down

TWO FACTS JOINing? Empty TWO FACTS JOINing?

Post  SathyJaanu 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

Back to top Go down

TWO FACTS JOINing? Empty Re: TWO FACTS JOINing?

Post  ngalemmo 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.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

TWO FACTS JOINing? Empty Re: TWO FACTS JOINing?

Post  BoxesAndLines Wed Nov 18, 2015 4:40 pm

Yes, it's called drilling across.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

TWO FACTS JOINing? Empty Re: TWO FACTS JOINing?

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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