 |
 |
Archives of the TeradataForum
Message Posted: Fri, 30 Mar 2007 @ 09:55:23 GMT
| Subj: | | Re: View to Anonymize Data ?? |
| |
| From: | | D silva, Joseph Vinish |
| | We need to anonymize (ie make anonymous - I'm not sure it's a real word either) a field containing a 16 character account number (all
numeric). The first 6 characters should remain visible to the reader but the remaining 10 characters should be anonymized. | |
| | I presume the easiest way to do this is by creating a overlaying view - do any T-list members have any experience of doing anything similar
and any best practices I can lean on for this kind of thing. | |
The view looks like an Obvious choice, but then will they search based on the first 6 characters ? In that case you might find it helpful to
break it down and then create an Index on it.
Joseph D'silva
| |
