Skip to content

Managing Record Types

Overview

You can use record types to perform conditional masking of the file records. If a file has a different set of records spread across multiple rows, then the masking engine should be able to understand all the unique records. For example, a file has the following record in the first three columns of each row: first name, last name, and age. But the last column of each row has a unique record like IP address, ethernet address, etc. Then you must create a new record type for every unique record present in the file and assign a specific file format to all the record types.

Note

You must select a rule set that was created using a file connector from the Select Rule Set dropdown list on the left navigation pane. Record types are applicable only for delimited and fixed-width file type connectors.

Adding Record Types

Perform the following steps to add a record type:

  1. Create a record type for each distinct type of record (for each distinct list of fields) and assign each a file format.

    1. Navigate to Environments > Inventory and click Record Types.

      The Record Type window appears.

    2. Click +Add a Record Type at the bottom of the window.

      The Add Record Type window appears.

    3. In the Add Record Type window, enter values for the following fields:

      • Record Name — A free-form name for this record type.
      • Header/Body/Trailer — Select one of the following: Header, Body, or Trailer. Delphix allows the masking of multiple types of body records. If the file has header or trailer records, you will need to create record types for them. The Header or Trailer record type is used to specify a number of records that are not masked at the beginning and end of a file.

        If you selected Header or Trailer, then enter the Record Name and the Number of lines for the header/trailer.

        If you selected Body, then you must do the following:

        • # of Identifier fields - Specify the number of identifier fields.

        • Import Fields - Click on the Select button to browse for the file from which to import fields.

          Note

          The contents of the imported file vary for Delimited, Fixed Width, Copybook (Mainframe), and XML types.

        • ID # 1 Regular Expression — (optional) Specify the value of the record type code or another identifier that allows Delphix to identify records that qualify as this record type. A record type applies if its regular expression matches its specified identifier fields.

          Info

          This value is a regular expression that the masking engine uses to match the specified field to determine whether the record is of this type. For example, the expression "C_([A-Z]){2}" can be used to match C_IP for the type C records (as described in step 1 example).

        • Position # — (optional) Specify the field number (for delimited files) or the character position number (for fixed files) of the beginning of the Record Type Identifier within the data record.

    4. Click Save when you are finished.

  2. Modify inventory for each record type by clicking the Edit icon next to the ID of each record.

  3. Create and run a masking job. For more information, see Creating Masking Jobs.