Header Ads

How to bulk import data via IDD application of Informatica MDM?

1.Create an IDD application with the Subject Area Group and Subject Area's.If ROWID_OBJECT field is selected in the Subject Area,it should not be a 'required' field.


2.Create a data-import-template.xml file with the fields in the column layout of the Subject Area.The fields should be in the same order as the filelds in the subject area.

3.Import this template back to the IDD application.
4.Save,Validate and Redeploy the application.
5.The tab to import the excel file will be available now in the application.Browse and add the excel file that doesn't have more than 10,000 records.

4 comments:

  1. Hello Varsha,

    This is the most brilliant article ever! Please put the permalink part in the post. If someone didn’t comment on it I’d have no idea!

    I have created 3 entities from Provisioning tool (Person, Address ,Organisation) validated and published changes to MDM database.
    Now when I accessed on /cmx/csfiles on the browser, I got a list of services offered for that particular schema, and I imported the WSDL file into SOAP, I was able to see the web services for these entities.
    A mechanism for measuring the confidence factor associated with each cell based on its source system, change history, and other business rules. Defined at a column level for each contributing source system.
    But the problem is there are many unwanted parameters in the SOAP request. My goal is to provide this WSDL to downstream systems and they are trying to access the web services through this WSDL but too many parameters which are unwanted.

    Appreciate your effort for making such useful blogs and helping the community.

    Obrigado,
    Raj

    ReplyDelete
  2. I think this is the best utilisation of Informatica and its tools.

    Informatica Read SOAP API

    ReplyDelete

Powered by Blogger.