Access Management transformations protect sensitive data by applying filtering and data protections before your data reaches the target. The Access Management transformations apply data access policies that you create on the Data Access Management page in Data Governance and Catalog. You can configure these transformations for a selected set of tables on the Transform page of the task configuration wizard.
Keep the following considerations in mind when you configure Access Management transformations.
•When a data de-identification rule that replaces values with a constant value is applied to DECIMAL columns, the value written to the target might differ from the configured constant. If the constant's whole-number part is too large for the column, the value is clamped to the column's maximum or minimum. If the constant has more decimal places than the column allows, the extra digits are truncated. In both cases the job completes successfully without an error or warning. To ensure that the constant is written as configured, size the constant to fit within the precision and scale of every targeted column, or apply the rule only to columns that can accommodate the constant.
•For DECIMAL and NUMBER columns configured for data classification, the applicable data policy rule depends on whether the column includes a scale value. If the column includes a scale value, the DECIMAL data policy rule applies. If the column does not include a scale value, the INTEGER data policy rule applies.