cancel
Showing results for 
Search instead for 
Did you mean: 

MDM Value Mapping

Former Member
0 Kudos

Hi,

I am preparing myself MDM 5.5 Certification.

In Import Manager, when I am matching Source Field: Text

Destination Field: Text, I do not require Value mapping but I require it when I am matching the Numeric Data type to Text.

Is value mapping require when matching Source Field: Text to

Destination Field: Large Text?

Please can you give me some examples where Source Value of the field is needed to map with Detination Value of the field?

Regards

Kaushik Banerjee

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Kaushik,

Value mapping in MDM import manager is required when you are mapping a source field to a lookup destination Field,which has lookup values in the table within MDM.

We need to import the lookup tables prior to the mainntable in MDM.After doing so,when you perform main table mapping,MDM requests you the map the lookup values of teh source as against the predefined legal values already imported in MDM.

You also need to do similar value mapping for Hierarchy,taxonomy or boolean fields.

But for Text fields you need not to perform any value mapping.As you do not have any predefined set of values in MDM already existinga gainst which you need to map your incoming text values.

If you notice in MDM import manager for the value mapping pane.You have a column for Converted values.After the col for Source values.

MDM is designed in such a way that it coverts the source values data type automatically to the Destination field data type once you map the Field level.

So if you have mapped a Text field to a Numeric Field,then MDM internally converts the text values as per the numeric values.

As this is difficult to perform it may be asking you for a value mapping.

Do check the symbol as against the text values in the value mapping pane.it should be a small green dot.

lookup values do not have this dot rather have a column for mapping with the map symbol.

Hope It Helped

Thanks & Regards

Simona Pinto

Answers (1)

Answers (1)

michael_theis
Active Contributor
0 Kudos

Helle Kaushik,

value mapping is usually required if you map to a target field that contains a set of predefined values. This is the case for any lookup field. Usually you define lookups for specific codelists (e.g. countries). You define in MDM a set of countries that you expect in your message. If your message now contains a country code "US", you want to map the value to the existing country "USA", of course.

The situation is different for text fields. A text field can contain any value. Usually you do not expect a specific value in a text field. So you don't have to do a specific value mapping. The import action defines what happens with a text field. If it's set to create, replace or update all mapped fields, your text fields in MDM will be set to the values of the message. If the import action is set to update null fields only and your text field in MDM already has a value, the one coming in the message will be discarded.

BR Michael