We are planning to write Teradata UDF and call Hashing functions for masking sensitive data. WE use Arcmain to do data refreshes. Would like to know can we call UDF inside Arcmain, if not, Please let me know the best practice to mask the sensitive information as part of refreshing data in the lower environments.
How is arcmain used for refreshing? are backing up from one system and restoring to another? arcmain by itself doesn't handle any udfs, so you will have to mask the data before or after the restore depending on your need.