Column Masking

Database

Column Masking

Hi,

is there any way to mask the column with different value on teradata, like:

PersonID   PersonaName

1001         Thomas

1002         Jon

1001         Fred

-- output

PersonID   PersonaName   PersonaID_ch   PersonName_ch

1001         Thomas            312345           Taddfas

1002         Thomas            546789           Taddfas

1001         Fred                 312345            Adsfsdk

I cant use UDF, either it should be done through views or created new macro or add field on table.

Tags (1)
1 REPLY
Enthusiast

Re: Column Masking

Can you elaborate ? You want encode the values of columns ?