Hi, If you are using lookup file this means that you are not using segmented mapping algorithm but secure lookup one instead. Notice that it's more accurate to use segmented mapping for primary / foreign keys columns it will guarantee you the uniqueness value generation. Can you show an example of the values you have in your column that we can help. Regards, Mouhssine
HI, Sorry for the misunderstanding. So the rule should be number of unique values in the mapping file have to be equal or superior to the column once to guarantee that uniqueness values.
Can you confirm pleas if this is the case with you mapping file. Regards, Mouhssine
Hi, Just to complete the answer. I'm agree with Math's remarks the making job have to load on memory the 100K entries in mapping file before proceeding with masking and this spins up Performance / Maintenance questions. You will have to update the mapping file whenever it's needed to guaranty it have equal or more values than what you have in your columns. I still think that the easiest and smart way is to use segmented mapping algorithm, is there any particular reason for not using it in your case Regards, Mouhssine
Hi, I've got the point, could you give it try with SL algorithm you will have to generate a file with >= to the number of entries in the column. May be the hick is with how the algorithm is working, and the idea is try with a simple replacement with guarantee of preserving the realistic value meaning. Regards, Mouhssine