Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 30 Mar 2007 @ 09:55:23 GMT

  <Prev Next>   <<First <Prev

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

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020