The Data Map Creation utility, createdatamaps, can now filter columns in data maps based on column name. To apply column name filters, include the filterColumnGroup and filter elements in the control file. These elements are defined by the
FilterColumnGroup
and
Filter
complex types, respectively, in the schema file.
FilterColumnGroup Complex Type
The FilterColumnGroup complex type defines filtering criteria for a table or set of tables. The FilterColumnGroup complex type includes the following element:
Filter
Defines the filter criteria.
Type = Filter
Cardinality = 0 to 1
Filter Complex Type
The Filter complex type defines the filtering criteria for columns and optionally for tables. The Filter complex type includes the following elements:
columnName
Column name to be filtered.
The columName element accepts asterisks (*) and question marks (?) as wildcard characters. An asterisk represents one or more matching characters. A question mark represents a single matching character.
Type = string, length = 1 to 128
Default = FILLER*
Cardinality = 0 to 1
exclude
Whether to include or exclude column names that match the criteria.
Type = boolean
Default = true
Cardinality = 0 to 1
tableName
Name of table to which the criteria apply. If tableName is not specified, the filter criteria apply to all tables.
Type = string, length = 1 to 128
Cardinality = 0 to 1
For more information, see the "createdatamaps - Data Map Creation Utility" chapter in the