AnsweredAssumed Answered

Transformation consistent masking with FDM HASHLOV

Question asked by johnviot on Sep 7, 2018
Latest reply on Sep 7, 2018 by johnviot

Hello,

 

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)

 

Pumpmask:

______________________________________________________

-- SHEMA.TABLE
FUNCTION F_174537_3 (oldvalue in VARCHAR2)
RETURN VARCHAR2 IS
BEGIN
RETURN gtsrc_scramble2('TABLE.COLUMN',NULL,50,'Y',PUMPW_174537_3.nextval,'N',null,'N',null,oldvalue,'HASHLOV','nombres_colombia_F','java');
END;

______________________________________________________

To consider:

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.

 

Versión FDM

4.7.400.12

 

Versión SCRAMBLE

VERSION 4.5.2 BUILD DATE 08 JUNE 2018

 

What I can do to solve this?

 

Thanks.

Outcomes