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.
Copyright © 2006, 2008, Oracle. All rights reserved.