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

MDM workflow data update conditional logic

Requirement:

During a MDM import is complete, i have a following scenario

lets say

i have new record added A2 and one of the field value in the record is A1 (eg. parent of A2). I want to update few fields for A2 record by fetching those values from A1 record (which already exists in MDM).

How can i handle this using MDM workflow?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 21, 2012 at 07:04 PM

    Hi George

    You can do next:

    Create syndication map for A1 record where you should to syndicate A2 record key and field values which you want to update in A2 record.

    Then

    Create WF with trigger action= Record import

    Your WF will consists of next steps:

    Start->syndicate->stop

    where syndicate contain your syndication map.

    Then

    You should to create import map for A1 data and in Checkout/Workflow property launch your Workflow.

    Then

    You should to create import map for A2 data.

    Then

    Create integration scenario for send your data from your syndication port (from A1) to your import port (for A2)

    Regards

    Kanstantsin Chernichenka

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 21, 2012 at 09:22 AM

    Hi Subin,

    I don't think your requirement can be achieved using MDM capabilities only i.e. Assignment, validations etc.

    But this could be achieved using Java APIs so that field values are compared first and then data is extracted and updated accordingly. You can update some flag in MDM after importing data so that search could be made easier for updation by Java API.

    One other approach could be:

    Syndicate those parent records(i.e. A1) by using some filter criteria or some expression to PI system.

    PI system will send back the data to some port and new map should be created where you can map Vendor Number(say) A1 to Parent Number. This field will be used for Matching purpose so that data is updated to those records which have A1 as Parent.

    While syndicating data you can use the expressions like Create Time stamp is last 1 hour and Vendor number is equal to Parent Number. Have to check the possibilities.

    Kindly check and let me know for any queries.

    Thanks and Regards,

    Ankush Bhardwaj

    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.