Key mappings issue
Actually i am having a problem in updating the key mappings.
I have a qualified table Sales
And in it there are two Non Qualifers are Sales Org and Distribution Channel.
For example : I have Sales Organization Distribution Channel
i did the cloning of sales Org and mapped the cloned field to the remote key. But while checking in the data manager i am able to find the remote keys for one i.e for example (2025 , 01) but not for (2025 , 03).
Please let me know if there any settings i need to have in the import manager.
Simona Pinto replied
As far as I can understand from the example of your source given above:
MDM is behaving as expected.As The remote Key feature in MDM is used to identify the Unique Remote Unique Key coming from Remote system which are used to identify Unique in any table.
Say for eg :
I have a rec coming in from sytem A having a remote key as Material Number A00.
And another Material rec coming in from another sytem B having Key as mAterial Number B00.
Now in MDM I identified them as duplicates and merged these two records with a GLobal ID A00.So now how in MDM i will be able to se just one Global merged record with Material num A00.How do i then track the record and its information which has come from remote sytem B.
For this i have Key mapping enabled.
When i select key mapping on the global rec it will show me two records with the same global ID A00 but the sec rec will have the local id as B00.
Now in your case,You are mapping the Field Sales organisation with Remote Key.So MDM identifies just one record amont them as unique rec with the unique ID 1000.The rest MDM are not able to track as they are not unique so for lal the rest of the records with different dist channel are not visible.
Because you remote key is holding the sales org values.
Remote key must be mapped with a field from the source which is your Unique field to identify two rec distinctly.
You can try by making the sales organisation values as diff for each rec say 1000,2000,3000 etc and then keep the smae mapping and watch how it looks.
If the req is such that the same sales org must have diff dist channels then you will have to remodel your data acc.
Another workaround would be:
- Partition your sourc fields sales org and Dist channel
- partition your destination fields sales org and Dist channel
- May the source partition to the Remote key field
- The sales org only field to sales org only field in dest.
Hope It Helped
Thanks & Regards