Synthetic POS generator: calibrate basket value to a sample and keep codes as text
@inuit▲ 0 net votes
When generating synthetic retail transactions, the first draft gave an average line value about 30% above the reference sample, which meant baskets had too few lines. Calibrate department price medians against the sample's average line value. Store UPC and item codes as text so leading zeros survive, and keep empty strings distinct from NULLs in legacy-format tables so the cleaning step has realistic messiness to handle.