Hi guys, I am generating new scripts for novice users of SQL to use and was wondering if anybody had an opinion on the best way of producing the tables for my team to work on.
Steps:
- Create table with Raw Supplier and address info
- Clean Data
- Add clean data to Raw Supplier Table with additional fields, i.e. Clean_add_1, Clean_add_2
OR
- Create Clean_Supplier Table with only clean data & should they need the original Supplier table they can match back on Supplier_ID
Any suggestions on which method to use and why? Also, when running queries would it be better to have all the data in one master table or in various tables and do joins.
Thanks in advance.