cancel
Showing results for 
Search instead for 
Did you mean: 

How Consolidated Master Data Gets Linked to the Transactional Data?

former_member496675
Participant
0 Kudos

Hi,

Suppose we have three legacy systems holding customer master data. We fetch the data from these three systems into MDM and consolidate the records. Let's say there were three customer master records:

CUST123, John James, 123 Elm Street

CT00123, James, John, 123 Elm St.

0000123, John James, 123 Elm Street.

We merge them in MDM and create one record

NEWCUST123, James, John, 123 Elm Street

Question is: How the transactional data from the three legacy system will be mapped to this new customer master record? How the purchase orders will know that CUST123 is now NEWCUST123 ? When this mapping happens in a project and who does that?

Regards,

-T

Edited by: mdm3north on Jul 21, 2011 2:30 AM

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

While uploading the transaction data , we need to make the system to look into the mapping table to find out the new value for old Customer value.

We have to write code for this in the start routine of transformation on transactional data.

Regards,

Anil Kumar Sharma .P

former_member496675
Participant
0 Kudos

But who creates this mapping table? I know when we import data into MDM, we can create a key mapping in MDM. Is that where you would look to find the old key to new key relationship? Or would you create a mapping outside MDM?

Regards,

-T

Former Member
0 Kudos

Hi,

You have to use the key mapping table that you created.

Regards,

Anil Kumar Sharma .P

Former Member
0 Kudos

HI,

I agree with Anil on that,it is the same reason for which few projects have key mapping repository in place,which holds the key field mapping information telling them that this Customer number means this in the Legacy system.

Well manual intervention is required as PR/PO which is active should be closed before such an activity.

Thanks,

Ravi