Delete Stream

The Delete Stream operator converts the deleted records of a changed relation into a stream. The operator takes all records that are in a previous table but not in the current table, and puts them into a stream with a timestamp.

Use the Delete Stream operator when you need to place deleted records from a relation into a stream.

To Create a Delete Stream Operator

1. Drag a Delete Stream operator from the Palette to the Design view.

2. Connect the input side of the Delete Stream operator to a relation output.

3. Double-click the Delete Stream operator.

   The property editor opens.

4. The Details section of the property editor displays the name of the operator and the output schema.

5. The Attributes section provides a picture of the current state of a stream.

6. Click OK.