|
Answer» To avoid synthetic keys, there are ways to solve this in data load script.
- Keys that are to be used have to be logically linked to two tables. Fields like “Comment”, “Remark” and “Description” can still PERTAIN in some tables without being linked and thus couldn’t use them as keys.
- Data like “Date”, “Company” and “Name” can pertain in some tables and can have same values with VARIOUS (Order Date/Shipping Date, Customer organization/Supplying Organization). In related cases, these cannot be used as keys.
- Need to note that redundant fields are not being used- as only ESSENTIAL fields connect. If for example, a date when used as key, ensure that it doesn’t load year, month or day_of_month of similar date of more than 1 internal table
- When essential, from own primary keys, characteristically using STRING concatenation under a function of AutoNumber script.
To avoid synthetic keys, there are ways to solve this in data load script.
|
