In general, are the generated values of fields such as SSN as unique as possible?
I realize that it is possible to run out values in any limited domain, so asking for more SSN’s than 999,999,999 records would necessarily duplicate values in the generated output. However, if I ask for 999,999,998 records, for example, will they all be unique?
Does the same answer hold for other limited domains of values?
No, general Mockaroo data is random, with no guarantee or effort towards uniqueness. Uniqueness is very hard to accomplish at scale. Mockaroo uses multiple concurrent processes to generate large scale datasets quickly. That architecture does not lend itself to guaranteeing uniqueness because the processes work independently.
That makes sense. Thank you. One would need to utilize various tricks with the row number (sequence) then.
(post deleted by author)