- Home
- Developer Center
- Documentation SSIS Data Masking Components
- Names with Gender
- Home
- Developer Center
- Documentation SSIS Data Masking Components
- Names with Gender
Names with Gender
Purpose
The Masking Name with Gender component takes a first name as input and returns a randomly substituted first name that matches the person's gender. Unlike the dynamic version, this component introduces variability—the same original name can be replaced with different masked names each time the process is run.
The component supports two usage scenarios: explicit and implicit:
- Explicit Scenario
- Manually define gender values and specify the gender column:
- In the Component Properties tab, configure all possible gender field values (e.g., Male, Female, M, F).
- In the Input and Output Properties tab, set the "Gender Column" property of the relevant column to True.
- Manually define gender values and specify the gender column:
- Implicit Scenario
- The component automatically infers the gender based on the input name using a predefined dictionary.
- No need to configure a gender column.
- The component automatically infers the gender based on the input name using a predefined dictionary.
The substitution logic also handles names that are used for both males and females. If the input name is not found in the dictionary or its gender is ambiguous, the component selects a replacement from a set of gender-neutral names, ensuring that gender consistency is still maintained.
This allows for realistic and privacy-compliant masking while respecting the gender context of the original data.
Algorithm
Data Masking Components: Names with Gender