combine order, invoice, and backlog detail in one fact table
2 posters
Page 1 of 1
combine order, invoice, and backlog detail in one fact table
I am thinking of combining the order, invoice, and backlog detail in one fact table. They all have the same dimensions and level of grain. The total of the invoices = orders+backlog.
I don't see any benefit in having 2 fact tables. One with invoice detail and one with order and backlog(open orders) detail.
Do you see anything wrong with this?
I don't see any benefit in having 2 fact tables. One with invoice detail and one with order and backlog(open orders) detail.
Do you see anything wrong with this?
soup- Posts : 2
Join date : 2013-03-05
Re: combine order, invoice, and backlog detail in one fact table
Yes. An order and an invoice are entirely different things. You may consider creating an aggregate of the two, but I would not replace the two facts with a single fact.
soup- Posts : 2
Join date : 2013-03-05
Similar topics
» Order dimension vs. order degenerate dimensions in the fact table!?
» Need to merge fact tables
» Modeling invoice detail with rebate detail
» Transactional detail fact table w/complimentary snapshot table. How do the two play together?
» Fact Table(s) for Invoice Lines with Further Granularity
» Need to merge fact tables
» Modeling invoice detail with rebate detail
» Transactional detail fact table w/complimentary snapshot table. How do the two play together?
» Fact Table(s) for Invoice Lines with Further Granularity
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum