Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

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


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


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