Page History

...

Configure DB component as mentioned in the "PrerequisitePrerequisites" section above, so that query can be invoked using the Feeder component sent to Aggregator.

...

1. Double-click the Aggregator component to open the Configuration Property Sheet (CPS).
   
   
   Figure 2: Aggregator CPS
   
   
2. Under Attributes section in the Configuration dialog box, click the Completeness Condition attribute and select the value "Wait For 'N' Messages".
   
   
   Figure 3: Setting Completeness Condition
   
   
3. In the new attribute—Completeness Message Count that appears, provide the value '3'.This makes the Aggregator wait for 3 messages and then aggregates into a single output message after the receipt of 3 messages.
   
   
   Figure 4: Setting Completeness Message Count
   
   
4. Select the Input Ports XSD attribute and click the Ellipsis button.
   
   
   Figure 5: Selecting Input Ports XSD Schema
   
   
5. In the Input Ports XSD dialog box, click the Fetch From Connected Source button present in the bottom-right part of the screen. Inthe Connected Ports dialog box, select OUT_PORT and click OK to fetch the XSD from DB output port.
   
   
   Figure 6: Connecting to DB component output port
   
   

6. XSD Schema appears in the editor and the root appears under Select Root Element next to the Ellipsis button.
   
   
   Figure 7: Input Port XSD editor with the DB Schema populated

   Info
   'sel' in the above schema is the Select statement configured in DB component and the elements under it represent the columns

7. Retain the IgnoreDuplicateMessages attribute value as 'yes' to ignore the messages that has the same content in the Duplication identifier.
8. Retain Duplication Identifier attribute value as 'Text Body' so that the message having the same content in Text Body as that of a previous message will not be taken into account for aggregation.
9. Select Duplicate XPath and click the Ellipsis button. In the XPath Editor dialog box, perform the following actions and click OK:
   1. Delete the default element present in the right side panel to restrict the duplicate check to a particular element than the entire content.
   2. Drag the element 'STUDENT_ID' present in the left panel to the right panel.
      
      
      Figure 8: Selecting STUDENT_ID under Select query as Duplicate XPath
       
   3. Similarly, click XPath Ellipsis  button and drag the element 'PLACE' to the right panel after deleting the default element in the XPath Editor dialog box.
      
      
      Figure 9: Selecting PLACE under Select query as Duplicate XPath
       
10. Click OK to close the XPath Editor and click Finish in the Configuration CPS to save the configuration.

...