ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

HASHLOV return duplicate value

book

Article ID: 213340

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

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.

Environment

Release : 4.9.1

Component : CA Agile Requirements Designer - TMX Script Generator

Resolution

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.