MDM Value Mapping
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?
Simona Pinto replied
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