When to use qualified lookup table?

[Former Member]

Hi all,

I am confused with the qualified lookup table and lookup table, for the situation that a company has more than one contact person, I created a table "contact person", which has following fields: first name, last name, phone number, email address.

Questions:

1. should I set "contact person" as a lookup table or qualified lookup table?

2. if to be set as qualified lookup table, which field should be qualifier field? what is the difference between qualifier field and non-qualifier field?

your reply will be very appreciable

Bin

[Former Member · Accepted solution]

Hi Bin,

I suggest you read this <a href="/people/pooja.khandelwal2/blog/2006/03/29/taming-the-animal--qualified-tables

Regards

Suman

[Former Member]

At times data is stored in such a way that duplication is unavoidable due to the storing mechanism and other factors. It may also happen that the data is sparse. The efficient way of storing data in such scenarios is the use of Qualified tables as it reduces the size of the main table and removes the unnecessarily created duplicates.

Check the foll links

/people/pooja.khandelwal2/blog/2006/03/29/taming-the-animal--qualified-tables

/people/avi.rokach/blog/2006/11/14/using-mdm-55-for-data-quality-analysis

MDM data modelling guide

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/5d4211fa-0301-0010-9fb1-ef1...

How to import Qualified tables.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/abe914fa-0301-0010-7bb1-d25...

Also this one.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/792f57b7-0a01-0010-f3b6-881...

Please reward for the same.

[Former Member]

Hi both, thanks very much, the documents are really informative, helps me a lot!