is there any way to mask the column with different value on teradata, like:
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.