Re: Star Schema from 'Flattened' CSV
From: Aaron Peters <transreductionist_at_gmail.com>
Date: Thu, 2 Nov 2017 16:32:55 -0700 (PDT)
Message-ID: <be6b1334-18bd-4639-ad6b-01ae14732861_at_googlegroups.com>
Date: Thu, 2 Nov 2017 16:32:55 -0700 (PDT)
Message-ID: <be6b1334-18bd-4639-ad6b-01ae14732861_at_googlegroups.com>
[Quoted] Not sure what you are suggesting. Is this a correct assessment? I can go one of 2 ways:
- Use 2 fact tables with 1 dimension: One fact table for vendor 1 One fact table for vendor 2
fact_performance1 fact_performance2
- unit_price - unit_price
- tot_sold - tot_sold
- tot_ret - tot_ret
- vend1_price - vend2_price 2. Use 1 fact table with 2 dimensions A dimension for vendor 1 A dimension for vendor 2
fact_performance dim_ven1 dim_ven1
- total_sales - ven1_name - ven2_name
- total_units_returned
- total_units_sold
- vend1_price
- vend2_price