Manage mapping actions - Precisely Data Integrity Suite

Change dataset mapping

Update how tables in a schema are mapped by selecting tables and configuring mapping options.

1. Select tables in the schema.
2. Click Change Mapping to open the Change Dataset Mapping dialog. The counter shows the number of tables selected.
3. Select Use a pattern or Specify or use an existing topic from the Topic dropdown.
   Note: If Use a pattern is selected, enter a topic name.
4. Select a value from the Case dropdown to set the display case of the topic name.
5. Click Apply.

Change field mapping

Change field mapping for a subset of selected tables.

1. Select the rows you want.
2. Click Change Mapping to open the Change Dataset Mapping dialog. The counter shows the number of tables selected.
3. Select Map fields by or Include row metadata fields from the Changes tab.
4. Select the Defaults tab to set default field mapping values.
   Note: Default values only apply to targets that do not yet exist.
5. Click Save.
6. Click Update Defaults to override values from the Defaults tab for all tables.

Set column mapping

Align source and target columns, specify actions (Copy or Ignore), and designate distribution keys.

1. Click Map Columns. The Column Mapping screen displays.
2. Select the columns to map.
3. Select Copy or Ignore for Action.
4. Choose distribution keys by selecting the checkbox for each column.
5. Toggle Reorder target columns to reorder columns by drag and drop.
   Note: Reorder target columns is only available when the target does not exist or exists without a schema.

Change table mapping

1. Select the rows from the table.
2. Check Create topic if it does not exist.
3. Click Change Mapping to open the Change Table Mapping dialog.
4. Select Use a pattern or specify an existing topic.
   Note: If Use a pattern is selected, enter a combination of source columns, schema, and tokens. Since Kafka does not support spaces, only underscores and hyphens are allowed as special characters.
5. Select a case option for letter casing.
6. Click Apply.

Add filter

Add filters to refine the data selected for replication by specifying conditions that include or exclude rows from source tables.

1. Click the Schema dropdown and select the schema containing the table to filter.
2. Click the Table dropdown and select the table.
3. In the Filter expression field, enter a Boolean expression. For example, Country == 'CAN' includes rows where the Country column equals Canada.
4. Click Validate Expression. Results appear in the Validation results field.
   Note: You can still save the filter even if validation fails.
5. Click Add to save the filter.

Soft delete for table targets

Soft delete retains deleted source records in the target instead of removing them.

Enable soft delete

1. Select the datasets to enable soft delete for.
2. Click Soft delete and choose Add soft delete.
3. Review the impact in the dialog:
   • Created tables: Soft delete is added automatically. You can bulk-name the soft delete field, configured on the field mapping page.
   • Existing tables: Add a new boolean-type field on the target or select an existing one.
     Note:

     • Mapping soft delete to an existing field overwrites data in that field.
     • If no boolean-type field is available, soft delete cannot be added.
   • Mixed selection: A modal prompts you to complete actions for both created and existing tables.

Once enabled, an icon appears next to each dataset. When adding soft delete to created datasets, the field name is autofilled.

Disable soft delete

1. Select the datasets to remove soft delete from.
2. Click Soft delete and choose Remove soft delete.
3. Confirm the action in the dialog.