Re: Star Schema from 'Flattened' CSV

From: Aaron Peters <transreductionist_at_gmail.com>
Date: Thu, 2 Nov 2017 15:22:41 -0700 (PDT)
Message-ID: <12c76c03-1698-4cfe-ac23-dc0bb97a11ed_at_googlegroups.com>


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 data warehouse with a fact table for each vendor. Is this the best way to handle this? Received on Thu Nov 02 2017 - 23:22:41 CET

Original text of this message