TWO FACTS JOINing?
3 posters
Page 1 of 1
TWO FACTS JOINing?
Can two facts table be joined a common dimensional table?
FACT1 ->Dim 1
Fact2--> Dim 1
Fact1--->Dim1--->Fact2
FACT1 ->Dim 1
Fact2--> Dim 1
Fact1--->Dim1--->Fact2
SathyJaanu- Posts : 20
Join date : 2015-10-07
Re: TWO FACTS JOINing?
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.
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.
Re: TWO FACTS JOINing?
Yes, it's called drilling across.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» Joining facts through conforming dimensions
» Fact Tables Joining to Factless Facts
» Multiple Facts or Single Facts and Status Table?
» How best to model Timesheet facts against Sales Order facts
» Identify the facts and facts grain
» Fact Tables Joining to Factless Facts
» Multiple Facts or Single Facts and Status Table?
» How best to model Timesheet facts against Sales Order facts
» Identify the facts and facts grain
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum