Skip to Content
author's profile photo Former Member
Former Member

MDM Qualified Table Question

Dear MDM specialists,

Wanted to check this :

Main Table has 2 records :

Record 1

Record 2

and each record has a main table field "PRICE" which is linked to a qualified Lookup table.

The qualified lookup would be showing Price by the State.

For Record 1,the main table field PRICE would have 2 values like the below :

10 USD for NY

20 USD for KY

Now if for Record 2,the PRICE has a value of

10 USD for NY

20 USD for SC

30 USD for CA

Will the value pair 10 USD for NY be stored 2 times in the qualified table ?

or the Relationship between the main table and Qualified table would take care of that ...meaning the qualified table would always have just most normalised records without any redundancy.

Thank you.

Josh

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Oct 27, 2006 at 03:08 AM

    The value pair 10 USD for NY will be stored only once and there will be two relationships will be estiblished, one for each main table record to Qualified table record.

    Abhay

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 27, 2006 at 04:57 PM

    Josh,

    Qualified table in MDM is not just any other table in MDM that holds all records at one place. Qualified table has two types of fields: Non-Qualifier and Qualifier fields. Non-Qualifier fields decide whether there should be multiple records or not.

    In your case, just goto Data Manager, select table as your Qualified table in the drop down for the table name: you will see entries only for Non-Qualifier fields (This should answer your question - How many actual entries are available within the Qualified table?). You can not maintain them from here - but need to be done from the MAIN table only. Internally within MDM, this data is treated as part of MAIN table record and is loaded dynamically from different underlying tables at the time of displaying qualified table data from MAIN table.

    Hope that helps,

    Rajani

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 30, 2008 at 06:59 AM

    As you said, a Qualified table will always contain normalized set of records. In this case the value pair 10 USD for NY will be stored only once. The relationship between records will be established when you select the records from the Qualified table for the main table record.

    Thanks,

    Nikhil Goyal

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 30, 2008 at 07:21 AM

    Hi Josh,

    Qualified lookup Table has two type of fields :

    Qualifiers( Whose value can vary for each main table record)

    Non Qualifiers ( Fixed set of records)

    Now while importing values for Qualified table u always import Non Qualifiers first which get stored only once (As u said)

    And Non qualifiers are imported every time u import main table record...... Now here if u have same Qualifier values for 2 main table records then they get stored twice.

    Now in ur case Country is Non qualifier field coz its having fixed set of values..... NY,Ky,CA,SC.

    But Price is Qualifier coz its value can be anything.

    So all countries will be stored only once...... & will get linked to ur each Main table record.

    But Prices will get stored seperate for each main table record.

    Hope its not confusing 😊

    Thanks,

    Maheshwari

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.