PII property in DM (4252595)

Scenario:

I made certain column as PII Personally identifiable information. But I cant see any difference in the script generated by Erwin. Can I generate the PII property while generating the DDL?

Solution:

PII (personal Information Indicator) is for information only; it only marks the Columns which need to be flagged as PII. This is generally done using the masking which is different for different databases. For SQL Server you can see under 'SQL Server' tab in Column Editor (It should be same or similar for other databases where this feature is supported in). There are options for Column Mask Option and Column Encryption Key and Encryption Type. Those properties are used in the syntax.