on 04-21-2007 10:20 AM
Please knidly help to explain, in which case the filed should be single-valued, or multi-valued?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you, Mark. I get your point.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.