Table of Contents

Search

  1. Preface
  2. Introduction to Mass Ingestion
  3. Prepare
  4. Create
  5. Deploy
  6. Run
  7. Monitor
  8. infacmd mi Command Reference

Mass Ingestion Guide

Mass Ingestion Guide

Replace Criteria

Replace Criteria

The replace criteria determines how to replace column values in the target table.
Configure the replace criteria to replace values in columns according to the entire string or a pattern.

Replacing an Entire String

If you configure the replace criteria to replace an entire string, all values in the columns that you specify are replaced according to the new value that you configure. For example, you configure the criteria to replace values in columns
COL1
and
COL2
and configure the new value to be
XXX
. All values in columns
COL1
and
COL2
are replaced with the value
XXX
.
The following image shows the options to configure the replace criteria based on an entire string:
This image shows the Mass Transformations page when you create a mass ingestion specification. A column is specified for the property Replace Columns. The property Replace Criteria appears below Replace Columns. In the property Replace Columns, Entire String is selected. Next to Entire String, you have the option to specify a value.

Replacing a Pattern

If you configure the replace criteria to replace a pattern, you enter a pattern and a new value to replace values that match the pattern. The pattern that you enter must be a regular expression.
For example, you want to mask all values in a column that contains IP addresses. To match an IP address, you can enter the following pattern:
^(\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.(\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.(\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.(\d{1,2}|1\d\d|2[0-4]\d|25[0-5])$
All values that match the pattern are replaced according to the new value that you configure. If you configure the new value
XXX
, all values that match the pattern are replaced with
XXX
.
The following image shows the options to configure the replace criteria based on a pattern:
This image shows the Mass Transformations page when you create a mass ingestion specification. A column is specified for the property Replace Columns. The property Replace Criteria appears below Replace Columns. In the property Replace Columns, Pattern is selected. Next to Pattern, you have the option to specify the previous string or pattern and a value.

0 COMMENTS

We’d like to hear from you!