Currently we have one main table and we syndicate whole table once in day to the target system. Whole table contains 60,000 records. we syndicate whole 60000 records as 60 XML files(each 1000). For syndiaction we have a syndication map and a port.
Now I need to syndicate these records based on FIELD1 value. This field contains values as YES/NO. First we need to All records which contain FIELD1 = 'NO' and later records with FIELD1 = 'YES'.
I have one idea in my mind create two ports and two maps for YES and NO. Schedule NO records first and YES records later.
Can you please suggest any better ideas.