Re: Star Schema from 'Flattened' CSV

[Quoted] Not sure what you are suggesting. Is this a correct assessment? I can go one of 2 ways:

1. 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