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

MDM import manager, smart(er?) mapping within lookup list

hello everyone,

is any way MDM could in a smart way help to identify the value mappings to a look up list with more that one display field ?

lets make an example :

source field country : DE

destination table with two fields, both display fields : DE; Germany

MDM is not able to find them and make automap ...

I have try to make the mapping having only the code as Display field, and after changing to have both filed display, then MDM "forgot" the value mappings . Not really smart

playing with MDM 5.5 yet, planning upgrade soon

any idea ?

thansk in advance

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Nov 12, 2009 at 06:06 PM

    Hi Pedro,

    Refresh(import) Countries lookup table with Remote key values.

    While importing values to this table ,make sure you map country code [Clone] field in source to Remote key in destination.

    Cross check in Edit key mappings window, for a given remote sys >field name will be DE,Germany and remote key will be DE.

    Now, perform imports to the table > notice that , when you map country fields between source and destination, all the values of countries will automatically map.

    Pl let me know if you need any more help.

    Regards,

    Vinay

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 13, 2009 at 07:27 AM

    Hi,

    these are the rules for automatic value mapping:

    In general field values will only be mapped automatically if:

    a) there is value mapping information stored in the import map

    b) the source value is NULL and the Import Map configuration option Automatically map NULL values is set to yes

    c) the destination field has the type lookup table with key mapping and the source values are the keys

    Best regards

    Michael

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 13, 2009 at 11:08 AM

    Hi,

    In import manager both source field and destination field are with same then only automap it will take place

    EXM:

    Source field: DE

    Destination field: DE

    Then MDM it will automap countries DE to DE.

    Regards,

    Bhupal.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 16, 2009 at 12:58 PM

    so, resuming,

    there is no way that MDM would conserve the value mappings, when changing which fields are display, even the used field for the mapping keeps unchanged, isn't it ?

    is it even in the newest versions ?

    is going to be like that in the future ?

    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.