Syndicate depending on condition to a target field

[Former Member]

HI,

I am a scenario where I need to syndicate out the value depending up on the condition:

Source:

Remote System --AAA

value1---111

valu2---- null

Another record:

Remote System --BBB

value1---333

valu2----444

Target has two fields: System and Value

Condition is : When ever remote system is BBB then I need to pass value2 to Target Value field any thing else I need to pass Vlaue1 value to Value target field...

Is this possible in MDM Syndication?

Thanks

Rajeev

[Former Member · Accepted solution]

Hi Rajeev,

Yes it is possible in MDM 7.1 version

create two seprate map for each system (AAA,BBB) i.e. and set condition on each system

follow the the which may help you

1. Create field to field Map

2. In Map Properties Tab ---> Remote Key Over ride (AAA) & tiick suppress unchaged records

3. Specify Value1 = 111 and Value2= Null in free form serach

4. SAve map by selecting Remote System in our case it would be AAA

5. Give Map name & Save

follow same step for remote system BBB it will work

Note : Based on your Condition set in free form serach mapping will execute accordingly for perticuler system

Thanks,

Jignesh Patel

Edited by: jignesh patel on Sep 6, 2010 4:06 PM

[Former Member · Accepted solution]

Thanks All for your time and valuable inputs. Points are awarded.

[Former Member]

Hi rajeev,

For each remote system you need a different ports .

So for each port you can assign different map.

for system AAA map field value1 and for system BBB map field value2.

If my understanding is not correct abt yr scenarion then please correct me.

Thanks,

Sudhanshu

[Former Member]

Hi, I used remote system table as an example.. Iam using a qualifier tablewhich stores customer information and has a requirement to syndicate data based on condition to the same target field as stated above... Iam wondering is it possible with MDM 7.1?

Example:

mdmid,qualier table(type,value1,value2)

1,((AAA,111,null),(BBB,222,333))

I need to syndicate to a target field... Say type and value.. So I mapped type to type and value to value1...

When ever type is BBB then I need to pass value2 value else value1.

Is it possible?

Thanks

Rajeev

[Former Member]

Hi Rajeev ,

This can be achieved only by different maps.

In one map you set search criteria as remote systemas AAA and set map fields to value 1 and in another map yoou have to set

search criteria system BBB and map field value 2.

If this solution feasible for you then go ahead.

Thanks,

Sudhanshu

[Former Member]

Hi Rajeev

This is not possible as syndication always happens in a flat structure and we can not put a conditional statement for selecting the fields to be syndicated for record.

You can try 1 workaround-

Define one more field in data model and write an assignment exprssion such that it fulfills your condition-

When ever type is BBB then I need to pass value2 value else value1

Map this new field in the syndication map, should work fine.

Thanks-Ravi