Databases Reference
In-Depth Information
12. Save the changes we made and reload the script. The new data model will be
created and look as follows:
Two fundamental recommendations can be made regarding the creation of link tables:
• Always use the
Distinct
keyword when creating the link table. This is
done so we are only loading dimension fields into this table and we should
not have duplicate records.
• If the
Key
field is composed of several individual fields, it can be resource
intensive for the application. In these cases, we could use the
Autonumber()
function described previously.
Proceed to save and close the document.
Finding a balance
We have outlined two ways for dealing with multiple fact tables in a data model.
If we were to ask which of these methods is better, we would need to say, again,
"it depends." There is no definite best, and the decision about which to use will
depend entirely on the specific scenario where it has to be implemented.
