Forum Discussion
KeithChu
Helper I
Helper IRelationship: Star schema for multiple fact table
Dear all, I have two fact table (Sales Table, Gift Table) and they have common look up dimension table (Customer, Product, Calender, etc). I would like to filter out dimension based on fact, lik...
A schema can have one or more facts, but these facts are not linked by any key relationship. It is best practice not to join fact tables in a single query.Please refer these two very good articles:
Three ways to drill across by Chris Adamson
and
Should of the Warehouse - Drilling Across by Ralph Kimball
(from Stack overflow)