Skip to Content
author's profile photo Former Member
Former Member

Some Clarrification about Importing Data into MDM

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 25, 2009 at 07:03 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 26, 2009 at 02:59 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 25, 2009 at 07:02 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 25, 2009 at 07:10 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 25, 2009 at 08:00 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 26, 2009 at 09:00 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.