I has a SUBSET with a Transformatio Maps and I enable the option "Use Java algorithm for HASHLOV" to gives consistent masking with FDM.
I use the same list of values in both, FDM and Transformation Maps, I even used the same database. It works Ok, but if the Original value of the column has a lenght of 8 or if it has a space, the consistent don't works and It gives to me a diferent value.
(I tried fill the optión Hash Column to with the column to mask)
FUNCTION F_174537_3 (oldvalue in VARCHAR2)
RETURN VARCHAR2 IS
In this case I mask names and it takes a new name of a list of names.
I save the same list in the scramble database and I did a connection to the same database through FDM
The inconsistent presents only if the leght is 8 or if the value has a space (The tests I did showed this behavior, especially with the length of 8)
In the Options of FDM I keep empy the option MD5HASHLOV and I try change to "Y", is the same behavior.
I tried with a personal list and with a default list like "NAME - MALE SCOTTISH FIRST" but is the same behavior.
This happend in any column, is a normal varchar(50) without special configuration.
VERSION 4.5.2 BUILD DATE 08 JUNE 2018
What I can do to solve this?