data scrubbing/scrambling

[vitumati]

Hello Guys,


I have source with 2 columns,One is Account_No,second one is Account_Hold_Name.My requirement is need to data scrubbing/scrambling
data of first one(Account_No)
its not exactly Encrtpt and Decrypt.its data scrubbing/scrambling.

Example:
Account_No:ABC123456
We need to scrambling. the data like SR#*95471
For that we have write a logic.
A------>S
B-------.R
C------>#
1------->*
2------->9.......etc
can you please help me out this ?
Thnaks
VijayKumar-91-8806678186

[ArndW]

Code: Select all

Convert('ABC12','SR#*9',In.Account_No)

Will do what you wish.

[chulett]

Of course you would extend that to include all possible characters. And, of course, anything 'scrambled' like that can be easily unscrambled.

[ray.wurlod]

It's usually called "masking". Investigate IBM's Optim product, which has this capability, while preserving the relationships and statistics of the data.

[chulett]

Masking is similar but involves still having 'useful' data when you are done, this seems to be just... scrambling.

Here is a fairly recent discussion on the subject.