Some Clarrification about Importing Data into MDM

[Former Member]

Hi SDNers,

I have a small doubt. I know it is very basic.

I created a Import Map with only 1 Matching Field (PAN Number).

While importing data into MDM based on the PAN Number it will import.

In my repository I am having 100 records with same PAN Number.

If I processed same record again with same PAN Number.

At this point while importing it has to Check PAN Number. If the PAN number exists than it will update that record if that PAN number is not there then it will Create a Record. I think I am right.

My Doubt is : while Importing with PAN Number it will Check the PAN numbers available in Repository. (In my case I am having 100 Records with same PAN number.) it will update all 100 records and give output as 100 records

or

It will Merge all 100 Records and it will syndicate only 1 Record.

Can anybody expalin Import Process with Single Matching field from Importing to Syndicate with screens shots or Theoretically.

Thanks

Ravi

[Former Member · Accepted solution]

Hi Ravi,

Depending on the pan no. which is you rmatching field, you will be getting the match type.

If the record that you r trying to imoport exactly matches, then you can skip it setting default import action as skip.If you want to update only certain field you have the option of update all mapped fields or update or null fields.

Every action is manually. The system does not perform any action by default.

Also merging is a totally different concept and doesnt come into picture while importing records.

Hope it helps.

Thanks,

Minaz

[Former Member]

Hi Ravi,

As per your question, I am giving very simple example which will clear you doubt.

In my Data Manager: suppose i have 5 records(you can correlate this with even 100 records) with three fields(Name, Country, Profession) only as below:

Name Country Profession

Ravi IND Engr

Ravi PAK Doctor

Ravi IND Scentist

Ravi USA

Ravi UK

where the last two records maintained in data manager dont have any value for field Profession.

your Source file have two fields say(Name, Profession) with one record only as below:

Name Profession

Ravi MDMDeveloper

Map this two source fields with Repository Destination fields. In Match Records tab, Now I am sending data using import manager with only Matching Field Name: (in your case it is Pan Number)

In default Import Action you will get as below Details:

Active MatchLevel MatchType DefaultImportAction

1_of_1 Multiple Exact Here_you_can_select_different_Option_with_following_impacts:

On Selecting Default Import Action: Skip

Nothing will happen mean you will get same result as maintained earlier in your Data Manager

Default Import Action: Update(Null Fields Only)

Name Country Profession

Ravi IND Engr

Ravi PAK Doctor

Ravi IND Scentist

Ravi USA MDMDeveloper

Ravi UK MDMDeveloper

Default Import Action: Update(Mapped Fields Only)

Name Country Profession

Ravi IND MDMDeveloper

Ravi PAK MDMDeveloper

Ravi IND MDMDeveloper

Ravi USA MDMDeveloper

Ravi UK MDMDeveloper

Default Import Action: Replace

Name Country Profession

Ravi MDMDeveloper

Note: 1. Here all the Five Records will get deleted and you will find only one Record.

2. Value for field Country become Blank oon selecting Default Import Action: Replace as shown above

Hope it will clear your doubt,

Best Regards,

Mandeep Saini

[Former Member]

Hi Ravi,

The Importing of records into MDM is based on Matching Fields only. Now as per your scenario, your Matching field is PAN Number. When you import the records in MDM, the system will define the Match Class either as Exact, Partial and Conflict based on the text data file records that you created.

If your text file has same records repeatedly, then based on this the system places any one the above mentioned Match Type against those records.

And according to your requirement, you can choose the Default Import Actions available in the drop down menu againt those set of records.

All the above task can be done when you import the data for the first time into MDM. Now think that you have changed any one PAN Number from 100 records and you want to import the data again. In such cases, you have to decide whether the records needs to get updated r not.

Pls remember that now your importing for the second time. At this point of time, you have to choose the Default Import Action as Update (All Mapped Fields) or Repalce etc as per your requirement.. Note that system generates the Match Type by itself against those set of records and the rest of the records will have different Match Type which is generated by the system. Finally the data will be imported as per the Default Import Action type that you provide from the drop down list.

Hope this helped you.

Cheers,

Yash K

[Former Member]

Hi Ravi,

Importing in MDM happens based on your Matching field

The objective is to select a matching field that has unique values so that all records get imported.

It is a kind of deduplication happening at the import stage it self.

If you select the matching field such that it has duplicate values in it then a complete and correct import does not take place.

to take your ex:

You already have 100 records in MDM with the same PAN number.So now the question is for the second import are you reimporting those same 100 records with the same PAN number or 1 records with the same PAN Number.

For case 1:100 records reimported with same PAN number.

In this case MDM will check that the 100 incoming records are having exact multiple matches in MDM.

It means each incoming record has 100 exact match.So you can either update the MDM records with the incoming record values for the matching PAN number or replace those records with the new values.

For Case2:1 Record imported with same PAN number.

In this case MDM will check this record has multiple exact matches so if you say update all mapped fields then this one record values for all the other fields leaving PAN number will be updated for all the 100 records.

So it is basically the first record that is taken into consideration for updating or replacing the matching records in case of 100 matching records .As the first record is matching with all teh 100 existing records as its values get updtaed/Replaced for all the existing records .

You can understand thsi better with the below blog:

/people/deepankar.pandit2/blog/2008/04/10/delta-load-in-sap-mdm

Hope It Helped

Thanks & Regards

Simona Pinto

[Former Member]

Hi ravi,

It depends on your import action

Skip (By default) : Nothing will happen

Update (NULL fields only) : In all 100 record null values will get replaced by new values coming thr Import.

Update (All Mapped fields): all your 100 record will get updated with new record coming thr Import.

Replace: All 100 records will get deleted & new record will get created with values coming thr Import

Thanks,

Mahehswari

[former_member208981]

Hi Ravi,

Please refer the below on Import actions, which is the deciding factor for the data that is imported in Data Manager:

http://help.sap.com/saphelp_mdm550/helpdata/en/43/12036df94c3e92e10000000a1553f6/frameset.htm

(Matching records->Overview->Record Matching Concept / Import Actions)

From Match Class you can know if there is none, Single or Multiple records matching in the Data Manager, for the source record.

From the Match Type , you can know if there are any records already existing in data manager. It could be Exact, partial or Conflict. The difference between them is clearly explained in the above guide.

For Update(All Mapped Fields) : It will Update the matching existing destination record(s) with all of the mapped fields of the source record.

Replace : It will Replace the matching existing destination record(s) by first deleting them and then creating a new destination record based on this source record.

Skip : This will not perform any action.

So, if you are selecting Update(All Mapped Fields) , it will only update those record for the fields which are Mapped. You can check it in Data manager .

As for Merging is concerned, its done in Data manager, in Matching mode after you set up Strategies etc.

You need to select the import action, based on your requirement.

Hope it helps.

Thank you,

Priti