e
q
u
e
s
t
a
d
e
m
o < back
Data Masking Components: Date Rollup
Data{TOC}
"Last Name"
API Reference, CLR Reference (links)
Usage Instructions:
Purpose
Algorithm
Description
|
|
Usage Instructions:
| 1. Configure a source that contains the column with alphabetical and numeric characters. The data in the column may also include any other character that will be treated as a separator. |
|
|
2. Drag and Drop Masking |
|
| 3. Now, the precedence constraint (the blue arrow) passes proper meta-data to the Masking Date Rollup component. If you click on constraint, you will see: |
|
| 4. Now that the metadata for the Masking Date Rollup exists, and values are passed into the data masking component, please open the component editor: |
|
| 5. In the second tab, there are input columns. Please check-mark only one column, the one that you will be masking with Masking Date Rollup algorithm: |
|
| 6. This will create an extra column with the prefix “Masked_”. |
|
| 7. Create a connection manager for the destination and configure source component for the destination. In the connection manager, in the tab “Mappings”, specify that you want newly created Field_Masked to be a field replacing the original value. For that, just click on the available input columns, choose the masked value, and map to the “Available Destination Columns” |
|
| 8. Now, all the configurations are complete for the valid values. You can run the package with the Masking Date Rollup component, and see the results of data masking: |
|