MDM Qualified Table Question

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[former_member192347]

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