Accessing Non Qualifier Lookup flat field of an Qualified LookUp table

[Former Member]

Please find the datamodel for better understanding the question.

Product

-- Qualified LookUp table - field1(Field of Product table)

-- LookUp Flat table - field2(Field of Qualified LookUp Table)

-- field3 (Field of LookUp Flat table)

Question:

How to retrieve the field3 data?

Thanks in advance.

[Former Member]

Hi Himanshu,

the structure of ur table is as follows

Field1(Field of Product table) which is Non Qualifier

Field2(Field of Qualified lookup Table) which is Qualifier

Field3 (Field of lookup Flat table) which is also a Non Qualifier and looking up in another Flat table.

You want to retrieve the Field3 data which is non qualifier.

First you need to select the Qualified table and

Map the Non Qualifiers and import them

For Field1 there wont be any problem you can do direct mapping

But for field3 which is looking up in another flat table you need to do Field mapping and then do the value mapping (Add data on the destination side).

Now its turn for the non qualifiers open the master table and then again map the non qualifiers and also the qualifier fields.

Then create a compound field on the Qualifier (Field2) and then import this mapping.

Now after doing dis u will be getting the of all the fields (Field1, Field2, Field3)

Hope dis helps u

Regards Tejas .......

[Former Member]

Thanks for your responses.

Let me rephrase the question.

1.Products main table has a field field1 which is of Qualified Lookup table(Table1) type.

2.In the Table1 there is field2 which is Non-Qualifier of Lookup Flat table(Table2) type

3.In the Table2 there is field3 of type text has to be retrieved through MDM Java API.

The requirement is for each product id we have to retrieve field3.

[Former Member]

The issue is resolved.Thanks for your effort.

[Former Member]

How did you resolve this problem and retrieved field3?

Edited by: Manolis Anagnostou on Feb 16, 2011 9:53 PM

[Former Member]

Hi Himnashu,

Qualified lookup Table has two type of fields :

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

Non Qualifiers ( Fixed set of records)

If ur field Field3 Qualifier or Nonqualifier???

By retrieving do u mean Import?

If yes then..........

While importing values for Qualified table u always import Non Qualifiers first.

And Non qualifiers are imported every time u import main table record.

Go through this........... u will understand cocept of Qualified Table

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

Thanks,

Maheshwari

Edited by: Maheshwari Morbale on Feb 8, 2008 6:58 AM