Syndicate remote key value depending on a field value
Is it possible to syndicate remote key values depending on a particular filed value ?
Scenario is : I have three source systems AA,BB,CC... In between these source systems and MDM we have a Tool which merge and forward to MDM using a single remote system... so in MDM we have only one remote system (say REMOTE_SYSTEM)for all these systems.... While importing each system has there own information.. like system AA has a filed Role_Type AA and System BB has a field name Role_Type value BB and Systme CC has a field Role_Type value CC.. by this all three systems has a differnet records and Role_Type is the record identifier..
Now while syndication I want to syndicate if Role_Type value is AA then remote system key should be AA and if Role_Type value is BB then remote system should be BB and the same for CC..
is it possible?
Remote Value you set as REMOTE_SYSTEM, So this value canl be changed in following way:
As you can filter records with Remote system = AA using free-form search or drill down search.
Say you have 100 records total in data manager,and with Role_Type field value AA say you left with 30 records. After filter records when you send records out of MDM , it will still have REMOTE_SYSTEM Key. So either you need to replace this value for syndicating 30 records out of MDM using Syndicator or Intermediate tool
Using Syndicator, In Item tabs whatever name you given for your Destination field say RS, Unmap this Destination target field and then one way A). Set these Destination field Property in Destination Items tab as Required = click check-box and give(write) Default Text = AA, So in this way you can send all the 30 records which can have Value AA rather than REMOTE_SYSTEM.
Other way B) you can also create a Custom Item field in Custom Items tab and Put field Property = AA by typing manually and then can map this with target Destination field RS.
Similarly, You can filter for BB and then CC and can syndicate using Custom Items tab or by setting Destinations Item Map Property as said above after unmapped this field with existing source field.