Data model using Link Table: Best practices of adding new table to the model?
Hello,
I have data model that is using Link Table ( my LinkTable is created by concatenation of common fields from tables): What are the best practices to add new table to the model?
Should I have master calendar in LinkTable or as a separate table connected to LInkTable?
Should I concatenate or join new table to one of former tables? or to LinkTable?
Should I create new appended key to connect new table to LinkTable? If I create appended key in new table, I need to have the same appended key in LinkTable in order to create connection. But what to do if I do not have that one of the field in appended key in LinkTable yet, or not available among other tables at all? If I pull another field from former table to link table in order to create appended key to new table, it will create synthetic key.
