FILTERVIEW | NOFILTERVIEW
Valid for
Extract
Description
Use FILTERVIEW
to process SQL views by entering a view as the object in a FILE
or TABLE
entry. When processing views, Extract is actually processing the underlying table in the TMF audit trail. Extract internally maps the table to the view structure.
By default, when processing updates for views, Extract outputs a view update only if one of the underlying columns in the view changes. As a result, updates to the underlying table are not always output. Use NOFILTERVIEW
to ensure that a record is output whenever the underlying table is updated regardless of whether or not any of the view's columns changed. FILTERVIEW
ensures that records are output only when one of the columns changed.
Default
FILTERVIEW
Syntax
FILTERVIEW | NOFILTERVIEW