set RecCount = 500000000; // Number of records to generate Data: load chr(round(25 * rand() + 65)) & chr(round(25 * rand() + 65)) & chr(round(25 * rand() + 65)) as Customer, // Customer name between AAA and ZZZ chr(round(25 * rand() + 65)) as Product, // Product name between A and Z round(3 * Rand() + 2008) as Year, // Year between 2008 and 2011 round(1000000 * Rand()) as Actual, // Actual Revenue between 0 and 1,000,000 round(1000000 * Rand()) as Target // Target Revenue between 0 and 1,000,000 autogenerate(RecCount);