How to syndicate 1 record from Multiple Qualifer Table along with MainTable

[Former Member]

Hi All,

I have a multi Qualifier table which stores multiple values... While syndication I want to syndicate only one value and that should be the latest one.. Is it possible?

Qualifier Table has following fields

Desciption

StartDate

EndDate

I want to syndicate only one record which has the latest StartDate..

Thanks

Rajeev

[Former Member]

Hi Rajeev,

As per my understanding, I think this is not possible through MDM Syndicator. I feel that this thing can be taken care using PI where you can send the the latest qualified data record of StartDate and suppress all other qualified data records to respective remote system which are not latest qualified data.

@Sudhanshu:You are saying is not correct, as requirement is to send qualified data record with latest StartDate.

E.g I have two main table records and each record of main table has 2 qualified links:

Maintable(DF) Desciption StartDate EndDate

1 XYZ1 04/08/2010 03/08/2011

1 XYZ1 05/08/2010 04/08/2011

2 XYZ1 05/08/2010 04/08/2011

2 XYZ1 06/08/2010 05/08/2011

So as per requirement, only bold records should be syndicated and then updated in respective remote systems, you can not set their range in above condition. you need to compare among qualified records to see the latest StartDate associated with main table record. As Assignments/Validations does not run perfectly on qualified tables thats why i see this thing to be taken care by PI(XI).

Regards,

Mandeep Saini

[Former Member]

Hi Mandeep,

As you mentioned that

Maintable(DF) Desciption StartDate EndDate

1 XYZ1 04/08/2010 03/08/2011

1 XYZ1 05/08/2010 04/08/2011

2 XYZ1 05/08/2010 04/08/2011

2 XYZ1 06/08/2010 05/08/2011

Only the bold record will get syndicated.

I tried same thing at my end

What i did is that i have maintable record with qualified value like

product id porg(non -qualifier) start date(qualifier) enddate(qualifier)

1 porg1 08/03/2010 08/12/2010

1 porg1 08/01/2010 08/03/2010

in syndicator

1. in map properties i check the "filter qualified looup"

2. in free form search tab

2.1 for the start date i use abs>(greater than) 08/02/2010

after this i get only first qualified record in the xml

IS that i am not gettimg the requirement.

I am not able to understand where i m doing wrong

Thanks,

Sudhanshu

[Former Member]

Hi Rajeev

Syndicator is designed to syndicate a flattened file from MDM, also provides parametric search for filtering the records; but should not be used for comparative purposes as they can be more effectively handled in the PI middleware.

@Sudhansu- You are correct, putting a date in the filter for the syndication map will work but will have to be updated each time, which might nt be user friendly.

Hope this helps-Ravi

[Former Member]

Hi Rajeev ,

This working fine at my end .

Please try at your end whatever suggested in my last reply.

If you need some more info then please get back to me.

Thanks,

Sudhanshu

[Former Member]

HI,

I have the following XML output in the syndication...

<BUSINESS_PARTNER_ROLE>

- <PARTNER_ROLE UpdateTimeStamp="11/03/2009 18:22:56 GMT">

<ROLE>CRM000</ROLE>

<DATE_FROM>20090729</DATE_FROM>

<TO_DATE>20100729</Z_TO_DATE>

</PARTNER_ROLE>

- <PARTNER_ROLE UpdateTimeStamp="11/03/2009 18:22:56 GMT">

<ROLE>CRM000</ROLE>

<DATE_FROM>20050529</DATE_FROM>

<TO_DATE>20090729</Z_TO_DATE>

</PARTNER_ROLE>

</BUSINESS_PARTNER_ROLE>

From the above I need to send earliest start and latest end date...That is CRM00, 20050529,20100729

I need to send only one record of this Qualifier look table (Multiple) along with main table record... As you mentioned In free form seach I can set the customized date but I want to compare these table records and forward the least one out fo them...

2) Second scenario is: I have the following output in syndicator:

<BUSINESS_PARTNER_ROLE>

- <PARTNER_ROLE UpdateTimeStamp="11/03/2009 18:22:56 GMT">

<ROLE>CRM000</ROLE>

<DATE_FROM>20090729</DATE_FROM>

</PARTNER_ROLE>

- <PARTNER_ROLE UpdateTimeStamp="11/03/2009 18:22:56 GMT">

<ROLE>CRM000</ROLE>

<DATE_FROM>20050529</DATE_FROM>

</PARTNER_ROLE>

</BUSINESS_PARTNER_ROLE>

Then I need to send only the earlist date....

Wondering is it acheivable ?

Thanks

Rajeev

[Former Member]

Hey,

I am designing my repository according to yr requirement .Till then please try at your end.

Go to the free form search tab

In the start date and end date section ,there are operators that allow you to give the option to compare with current date or

any other date.

By selecting the date in free form search tab you can refine yr records.

"On the Map Properties tab, check the Filter Qualified Links property in the value section"

Please try at yr end.

I am doin the same.

Please revert back with yr resule