I want a reference relationship with a Business Unit table. The Business Unit table has an entity column where there are CountryAlpha2Codes like US,UK,SG.
How do I create a Reference Relationship between these two tables? Alternatively, can a Reference Relationship in xDM be configured to use CountryAlpha2Code (non-ID) as the foreign key, or must it always store the Country entity’s ID attribute? If so, how do i proceed to map/import CountryAlpha2Code in BU so that the BU → Country reference is set?
Bryan LEE
I am enquiring if Semarchy XDM has a way to choose the attribute to be used as a Foreign Key for the Reference Relationship.
An illustration:
I have a Country table, with the following attributes
CountryID (ID, auto-increment start from 1)
CountryName
CountryAlpha2Code (unique codes, e.g., US, UK, SG).
I want a reference relationship with a Business Unit table. The Business Unit table has an entity column where there are CountryAlpha2Codes like US,UK,SG.
How do I create a Reference Relationship between these two tables? Alternatively, can a Reference Relationship in xDM be configured to use CountryAlpha2Code (non-ID) as the foreign key, or must it always store the Country entity’s ID attribute?
If so, how do i proceed to map/import CountryAlpha2Code in BU so that the BU → Country reference is set?