Drag a Replay Stream operator from the Palette to the Design view.
Connect the output of the Replay Stream operator to any operator that accepts stream input (for example, the Stream Output operator).
Double-click the Replay Stream operator.
The property editor opens.
Click Select Table.
The Select Table which has Stream Events wizard appears.
In step 1 of the wizard, do the following:
In step 2 of the wizard, do the following:
In step 3 of the wizard, do the following:
By default, the Preserve Last Fetched Record check box is selected. This setting indicates that if the event process is redeployed, then the operator starts retrieving records where it left off.
If you leave the Preserve Last Fetched Record check box selected, then you must specify a table name in the Last Fetched Record Table field. This table will be created in the IEP database, not in the external database table.
If you want the operator to go back to the beginning of the table instead, then clear the Preserve Last Fetched Record check box.
(Optional) Click the Documentation tab and supply notes on this component.
Click OK.
The Replay Stream operator reads events from the database table and sends the events to the next operator.