Using the Stream Projection and Filter Operator Property Editor

See Also

The Stream Projection and Filter operator enables you to obtain a stream and for each event in the input stream and to:

Filtering Dimensions for an Event

When you add or remove dimensions to an event, you are using the operator to provide a filtering capability on attributes to add or remove attributes.

For example, you have information on a company that includes stock symbol and price but you want to filter out one of these. To do so, you can use the Stream Projection and Filter Operator.

Joining a Set of Events to One or More Tables

You can also join an existing set of events with one or more static table. If you do so, the output stream can have a different schema than the input stream's schema.

For example, you have information relating to an existing stock and its price, but you want to join a static SEC table to provide CEO and company size information. You are, in effect, adding a new dimension to the set of events in the input stream.

To create a Stream Projection and Filter operator:

  1. Drag a Stream Projection and Filter operator from the Palette to the Design view.
  2. Click the Stream Projection and Filter operator icon.The property editor opens.
  3. In the Expression box, enter the expression for the SQL Select statement which is used to specify the value of each output attribute. Add attribute names, data types. and sizes, as applicable.
  4. In the From box, define the input on which to perform the selection..
  5. In the Where clause box, provide filtering criteria on records and specify condition of a join if you are performing a join.
  6. Click OK.
See Also
 
Using the Relation Map Property Editor

Legal Notices