cancel
Showing results for 
Search instead for 
Did you mean: 

Single-valued or multi-valued?

Former Member
0 Kudos

Please knidly help to explain, in which case the filed should be single-valued, or multi-valued?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Alfred

Say you're storing employee information in MDM, and the employee data structure includes a "Country of Birth" field, and a "Nationality" field.

You can only be born in 1 country, so this field would be single-valued.

However, you can have multiple nationalities, so this field would be multi-valued.

Similarly, an employee could have "Preferred language" and "Spoken languages" fields. The "Preferred language" field would be single valued, while the "Spoken languages" field would be multi-valued. Both fields will lookup to the same table (Languages).

HTH

Mark

Answers (1)

Answers (1)

Former Member
0 Kudos

Thank you, Mark. I get your point.