Re: Star Schema from 'Flattened' CSV
From: Geoff Muldoon <geoff.muldoon_at_trap.gmail.com>
Date: Fri, 3 Nov 2017 15:34:32 +1100
Message-ID: <MPG.34669ce73dc0d8409896d9_at_news.albasani.net>
Date: Fri, 3 Nov 2017 15:34:32 +1100
Message-ID: <MPG.34669ce73dc0d8409896d9_at_news.albasani.net>
[Quoted] In article <be6b1334-18bd-4639-ad6b-01ae14732861_at_googlegroups.com>,
transreductionist_at_gmail.com says...
>
> 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
No.
[Quoted] dim_product
- prod_id
- prod_desc
dim_vendor
- vend_id
- vend_name
factless_quote
- quote_id
- prod_id
- vend_id
- price
- <date data>
fact_performance
- quote_id
- prod_id
- vend_id
- price
- <date data>
- <volume data>
Jerry: Star-schema models do not usually fully comply with Codd-style normalisation.
Geoff M Received on Fri Nov 03 2017 - 05:34:32 CET