Filter Single-Record Transformation Welcome Page

The Filter Single-Record transformation allows you to to define a subset of the data based upon attribute values, that is, to create a view that contains selected records of a table or view. You specify the records to include in the new view by creating simple or complex filter conditions. You create filter conditions by creating a WHERE clause for a SELECT statement. For example, if a table contains age information, you could use this transformation to create a view that consists of all records where age is greater than 21 years.

For information about Single-Record (nontransactional)format, see Table Formats.

The output of the wizard is described in Output.

If you do not want to see this page the next time that you launch the wizard, check the Skip this Page Next Time box.

Click Next to continue.