Skip to Content
0
Aug 16, 2023 at 07:01 PM

Randomizing sensitive data fields in Hana tables.

136 Views

I have a scenario where the data has to be randomized before hitting the DB tables for sensitive data fields like SSN, Salary ,AccountInfo as well as User details .Can I use the RAND () functionto do this ? Is it possible to do RAND on Date, NVARCHAR and string fields? If so, can someone help me here with syntax? Thank you.