HASHLOV return duplicate value
search cancel

HASHLOV return duplicate value


Article ID: 213340


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


We are trying to masking a table within an Oracle db.

The field to be masked was used to create a unique index, so in the table, all the values present within the field are distinct from each other.

Using the HASLOV function to masking the field using a seedlist, the problem arises due to the duplication of post masking fields.

The table contains approximately 16K unique data and the seedlist used contains approximately 400K unique values, so there should be no problem with masking.


Release : 4.9.1

Component : CA Agile Requirements Designer - TMX Script Generator


There are chances that, even unique values are also be assigned to the same hash value. So, it is not guarantee that, HASHLOV function maintain unique records. But the same value in input field will have same hash value. In that way, it maintain consistency.

    So, To generate unique records, you can go with alternate functions like FORMATENCRYPT or FORMATENCRYPT1.