This content has been marked as final.
Show 3 replies
-
1. Re: Implement a HASH function in BDM
Premkumar S Mar 30, 2020 8:55 AM (in response to Andres González Rubio)Hi Andés,
Are you looking to generate hash values through BDM?.
BDM has md5 function which will generate an 32 character unique value based on the columns which is used as input.
Refer this link.
Thanks
Prem
-
2. Re: Implement a HASH function in BDM
Andres González Rubio Mar 31, 2020 1:32 AM (in response to Premkumar S)Hi Prem,
we want to obfuscate the credit card numbers
Is there any other option?
thanks
Andrés González Rubio
-
3. Re: Implement a HASH function in BDM
Premkumar S Mar 31, 2020 2:43 AM (in response to Andres González Rubio)Hi Andres,
If you have DQ License you can try using Data masking transformation. It has a special option for Credit card masking.
MD5 is one of the option to encrypt your data.
Informatica also provides AES_ENCRYPT and AES_DECRYPT functions.
Feed you credit card numbers, with length as 16 string and the aes_encrypt can be captured in an output field of binary type.
See if that works.
Thanks
Prem