The Filter Single-Record transformation allows you to create a view that contains selected records of a single-record case format 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 case 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, uncheck the Show this page next time box.
Click Next to continue.
Copyright © 2005, Oracle. All rights reserved.