View previous topic :: View next topic
|
Author |
Message |
kishpra
New User
Joined: 24 May 2010 Posts: 92 Location: Pune
|
|
|
|
Hello Team,
I am working on a requirement where I have an accountNo col in 3-5 Production DB2 tables. I need to unload productions tables into test environment by masking accountNo col in all the tables.
accountNo col is CHAR(19) and I want to mask digits from position 7-18 in a way that this col is masked in a consistent way for all the records and for all the tables where it is referenced to maintain integrity.
Thank you. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
Quote: |
consistent way for all the records and for all the tables where it is referenced to maintain integrity. |
then a RYO approach is not the best way.
and if the environment is a financial institution the data masking stuff must go thru Your audit and be certified for compliancy |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3049 Location: NYC,USA
|
|
|
|
I think , you can make a use of seq# , I would advice you to talk to DBA in this matter also look CREATE MASK if that is what you looking for. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
the create mask IIRC is NOT PCI compliant
the unmasked data will still be present into the table |
|
Back to top |
|
|
|