Skip to Content
avatar image
Former Member

MDM key mapping: multiple fields?

Hallo,

is it possible to base key mapping on more than one fields?

From what i see key mapping is based on one field only...

Regards,

Marco

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jun 30, 2008 at 02:27 PM

    Hi Marco,

    If you want that You should not have duplicate records on base of more than one fields then you can make these fields as unique.

    I Guess i did nt get ur question properly. Could you please explain it to some extent.

    Regards,

    Dheeraj.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 30, 2008 at 02:27 PM

    Hi,

    is it possible to base key mapping on more than one fields?

    From what i see key mapping is based on one field only...

    yes, for that your field in Maintable should be Display field. So if you have two fields in Maintable then both of these fields can be used as key mapping in import manager while importing Data, in Match records tab, you can also have option of using these fields as Split or Combine as per your requirement on the basis of which you want to insert data into MDM Data Manager.

    Hope it will Help you,

    Rewards if Useful.....

    Mandeep Saini

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 30, 2008 at 02:38 PM

    Marco,

    If I can get your question correctly:

    We can have only 1 remote key field in Main Table to which you can map. Though you can maintain custom remote keys for lookups using sub tables...

    If my understanding is correct, out of interest could you please let me know why do you need more than 1 remote key field in main table?

    Regards,

    Dev.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank you all,

      basically my catalog data model has items with keys:

      - Material,

      - Supplier,

      - Material Group,

      and then price information that are different for backend logical systems.

      Each logical system has its own supplier and Material group numbering, so i wanted to know whether i can control these info (supplier and material group) by key mapping or whether i need to add logical system supplier and material group details in the price information.

      regards,

      marco