Source Data Identifier - Restrictions View (DBMS)

The source data identifier can be restricted to a specific metadata source type. Select DBMS from the list.

When you select DBMS, the data identifier only identifies source data fields when the metadata comes from a DBMS table and all of the conditions selected by checking the checkbox are true. If no boxes are checked, there is no restriction for the source data identifier even though there may be a value in the field associated with the checkbox. You cannot restrict to a specific type of DBMS. The names entered can be complete, or they can contain wild cards. The wild cards are asterisk (*) to specify multiple positions and percent (%) to specify a single position.

Source data fields will be identified only when all of the conditions selected are true.

Creator or Schema name: The source data identifier only applies when the metadata comes from a table with this creator or schema name. Check the box and enter the desired name to restrict disguise to a specific creator or schema.

Table name: Check the box and enter the desired name to restrict disguise to a specific table or view with this name.

Column data type and length: Check the box to select this option and specify a type and/or length as a restriction during identification. The field name is carried forward from the name you set on the Name and Fields view. The Type and Length fields can be populated either by dragging from View Coverage or by manually entering values. The types for defining restrictions vary by data source. The data type and length shown for the coverage display are the values that should be entered on the restriction.

The source data identifier only applies when the type and length of the field within the metadata matches the type and length specified in the restriction. If Type is specified but Length is not, field matching is based on the field name and the type. Similarly, if Length is specified but Type is not, field matching is based on the field name and the length. For example, with a restriction of type CHAR with no length specified, field matching will be based on the field name and type CHAR of any field length. Similarly, with a restriction of length 5 with no field type specified, field matching will be based on the field name and length 5 of any field type. If a restriction of type CHAR and length 5 is specified, field matching will be based on the field name, type CHAR, and length 5.

The specified names are not case sensitive unless the case sensitive option was selected for the identifier. The identifier name, the creator/schema, and the table name are all subject to the same case sensitive option setting.

Any field mask specified here is applied after normalization. A field mask of Y means to include the position, and N means not to include the position. The field mask can include a mixture of Y and N values. For more information, see Field-Mask-Processing.