Fact Table Design Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

T. - 18 Feb 2005 15:37 GMT

We're putting together our data warehouse, and I had a questions regarding
design of fact tables for our situation. We have invoices and payments to
those invoices...would I include all information in one fact table, or would
I separate them into two tables? If I do two tables, can I include two fact
tables in an OLAP cube?

Thanks in advance.

Reply to this Message

Rakesh Doebe - 23 Feb 2005 14:12 GMT

You can use a view....

it's even better to use a partitioned view...

Reply to this Message

Tomasz Borawski - 28 Feb 2005 10:53 GMT

Hi,
It’s really depending how often you will be analyzing invoices and payments
together.
Sometimes - you can built two cubes and join them into virtual cube.
Very often - you should include all information in your fact table design.

Tomasz B.

> We're putting together our data warehouse, and I had a questions regarding
> design of fact tables for our situation. We have invoices and payments to
[quoted text clipped - 3 lines]
>
> Thanks in advance.

Reply to this Message