Data Masking
Moderators: chulett, rschirm, roy
Data Masking
Hi All,
I need to mask varchar data. How can we achieve it without using data masking stage in datastage parallel job?
I need some process through which I can unmask it also later on if needed.
Can we use convert function on individual letters?
I need to mask varchar data. How can we achieve it without using data masking stage in datastage parallel job?
I need some process through which I can unmask it also later on if needed.
Can we use convert function on individual letters?
Why don't we start by you defining what you mean by "mask"? Examples are always good. I've found there's a lot of confusion out there about the term and sometimes people really mean encrypt or redact. Depends on how you'll be using the data afterwards. If you need to reverse the process, you're probably not talking about masking as it is not possible to undo it.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
If that's literally all you need to do then perhaps a simple cypher like ROT13 would work for you? Or some other letter substitution cypher of your own design? Both of those can be reversed. Keep in mind though, the simpler it is for you to build the simpler it would be for someone to break. If the security of this process / data is a major concern, you'll need to do something more complex.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
It's just a lookup table which lends itself to the Convert() function rather nicely. Or you could code something in C++ or even BASIC and use a Server job. All kinds of ways.
And there's absolutely no need to quote everything each time you reply, there's a perfectly lovely Reply to topic 'button' you should be using instead.
And there's absolutely no need to quote everything each time you reply, there's a perfectly lovely Reply to topic 'button' you should be using instead.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers