Qualifier and MV - confusion

[Former Member]

Hi,

Consider the following scenario:

Customer Name | Customer Number | Address Line 1 | Address Line 2 | Postcode | Home Phone Number

ABC | 1000 | 123 |XYZ |987 543 | 876543210

ABC | 1000 | 123 |XYZ |987 543 | 321098765

In MDM it should look like:

ABC | 1000 | 123 |XYZ |987 543 | 876543210; 321098765

I have to form such a schema.

I have Customer main table having qualified Address table. So 1 customer can have multiple addresses which shuits our reqmnt well. Noww 1 addresss can have more than 1 home phone number. So ideally we would have wanted another qualified table from Address qualified table. But so far this is not possible.

A workaround I am trying is to have Home Phone NUmbers as a MV look up. But when I try to import, import fails and when I see Data Manager i see only:

ABC | 1000 | 123 |XYZ |987 543 | 876543210

Though when I open qualifiers I can select and add 321098765 to the selection as well.

Regards,

Dev.

[Former Member]

Hi Debashish,

I got your point .But I guess you are talking about a lookUp Qualified inside a lookup Qualified table which i guess is not possible.But u can nest a lookup Flat table inside a qualified Table.

To your problem I have a different solution.

Let suppose Master record is as shown below:

Id | Name | Home_Add | Business_ADD | Landline | Mobile.

1 | abc | 123 | - | 078821 | 93709.

1 | abc | - | 345 | 080145 | 98932.

Here customer 'abc' have Multiple address like Home address and Business address.And each address has multiple phone numbers like Landline and Mobile.

In this case if you design repository as;

Main Table: ID,Name,Addres_Type

where Address_Type is a LookUp Quaified Field (multivalued)

Qualified Table:Address Type(Non-Qualifier),Landline(Qualifier)and Mobile(Qualifier),Address(Qualifier).

Address Type is a Flat LookUp Table with values Home address and Business Address.

After You Import in Data Manger your record will look like:

Id | Name | Address Type

1 | abc |Home Address;Business Address.

and when you see in Record detail pane for Address Type

you will find values like

Address Type: Home Address.

Landline : 078821

Mobile : 93709.

Address :123

Address Type: Business Address.

Landline : 080145

Mobile : 98932

Address :345

Hope this will help to solve your problem.If any further qury then do post to me.

Reward points if helpful.

Regards,

Neethu.

Edited by: Neethu joy on Jul 30, 2008 1:14 PM