Exporting Staged Data

Once a Staged Data table has been created with a Writer processor, an Export to write it to a Data Store can be created. The Export may then be manually run, or executed when the process that generates the Staged Data table is run.

To set up an Export of a Staged Data table:

1. Right-click on Exports in the Project Browser, and select New Export...:
   
2. Select the required Staged Data table.
3. Select the required Data Store.
4. If the table in the Data Store is not being created during export, select the required table in the Data Store.

   Note:

   The contents of this table will be overwritten by default. See Export Options below for further details.

5. If required, map the columns in the Staged Data table to columns in the target table:
   

   Note:

   Click on the Auto button to automatically map the columns in the order they are presented.

6. When the mapping is complete, click Next, and (if required) change the default Name of the Export (the default name comprises the Staged Data table and the name of the Data Store).
7. Either run the Export straight away, or save the configuration for running later (for example, as part of the scheduled execution of a job or process).