Dashboard > APATAR OPERATION GUIDES > Operation Guides > Aggregate Operation Guide
  APATAR OPERATION GUIDES Log In | Sign Up   View a printable version of the current page.  
  Aggregate Operation Guide
Added by Alex Khizhnyak, last edited by Michael Fedotov on Sep 10, 2008  (view change)
Labels: 
(None)

This tutorial will help you learn how to aggregate data fields from several sources into one target in Apatar.

Configuration

To aggregate data from two sources,

  1. Drag-and-drop the source and target connectors to Apatar's work panel.
  2. Then, drag-and-drop the Aggregate operation node.



  3. Double-click the connectors to configure them.
  4. Provide the mapping as shown in the picture below.



  5. Double-click on the Aggregation node. You will be switched to Aggregation mode.
  6. In the Input 1 tab in the left, data fields of the first source are displayed. Drag-and-drop the fields that you want to transfer onto the operation panel.



  7. Drag-and-drop the correspondent target fields onto the Aggregation panel.
  8. Provide the mapping.



  9. Now, switch to the Input 2 tab.
  10. Drag-and-drop the fields to be transfered from the second source onto the operation panel.
  11. Drag-and-drop the correspondent target fields again.
  12. Provide the mapping for these as well.



  13. Click Ok to exit the Aggregation mode.

Now you can preview the Aggregation results or run the transformation (choose Run from Apatar's File menu).

Previewing results

To preview the output data, right-click on the target node and choose "Preview Results".

See also

This RSS Aggregation demo will show you how to mashup three RSS feeds into a single custom feed, and publish it to the web.

Site running on a free Atlassian Confluence Open Source Project License granted to Apatar Data Integration (ETL). Evaluate Confluence today.
Contact Administrators