Re: Star Schema from 'Flattened' CSV
From: Aaron Peters <transreductionist_at_gmail.com>
Date: Thu, 2 Nov 2017 14:54:15 -0700 (PDT)
Message-ID: <3d31cbb6-8546-40fc-9493-dcb47287e727_at_googlegroups.com>
Date: Thu, 2 Nov 2017 14:54:15 -0700 (PDT)
Message-ID: <3d31cbb6-8546-40fc-9493-dcb47287e727_at_googlegroups.com>
[Quoted] Clarification from the author:
The first Star Schema is correct I believe. There is one product as it relates to one vendor's unit price. It meets the criteria for 1st normal form.
I understand that the CSV provided does not meet the criteria for 1st normal form, and this is of course the issue. From what I have read, one solution is to create a fact table for each vendor. Is this the best way to handle this?
As a note, there are 4 vendors, and additionally columns for 8 quoting companies as well, which I did not mention for simplicity sake. This would result in 32 normalized fact tables. Received on Thu Nov 02 2017 - 22:54:15 CET