March 27, 2024 at 3:25 am
Hi there, not sure if this is possible. Currently, I'm applying encryption on 3 columns in a table and populating the result to another table. The details from this table are then put out to a flat file and uploaded to an analytics system for analysis. The problem with this is whilst the encryption satisfied the requirement to have the unique field, it fails to keep the same encrypted value with respect to another value in another column. See below, I hope I'm able to explain this properly;
Account Number Account Name
1112223334 Jason
1112223335 Jack
1112223336 Jason
From the example above with the two columns, when I employ encryption, it puts out different/unique encryption values for the Account Name column even if their plaintext form is the same (which is how the algorithm was designed to behave), however, I've got a requirement for that to not be the case. They want the same encryption value to be generated for Jason.
Any ideas around this will be appreciated
March 28, 2024 at 4:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply