Skip navigation

3 Replies Latest reply on Mar 31, 2020 2:43 AM by Premkumar S

Implement a HASH function in BDM

Andres González Rubio Mar 30, 2020 8:46 AM

Hi,

Implement a HASH function in BDM

In BDM there are no fnv_hash () or hash () functions of impala / hive.

We need to implement a Hash that returns numbers

thanks

Andés Gonzále Rubio

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.

MD5

Refer this link.

Thanks
Prem
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions

Go to original post

More Like This

Legend

Correct Answers - 4 points