I have 2 tables loaded separately:
Table (1) Instruments (many prices)
Surrogate PK / Instrument name / Size / Unit
Table (2) Prices (1 instrument)
Price Id /Instrument Id FK / Instrument name / Price
What links both tables is the instrument name, my question is if I want to use an automatically generated PK for instruments table, how can I then link it to prices without previously linking them (prior to loading) by instrument? It can only be done by a join later on? Or should I be using the instrument actual name as PK so it can be linked?
I suppose the general question here is, if you load 2 separate data sets and want to link them, through a common field, is it more efficient to do that at PK/FK level or just Join them?
