Test Data & Parameterization

My performance test requires the following data:

Users: [N] unique users with credentials
Products: [N] product IDs
Orders: Pre-existing orders for GET scenarios
Dynamic inputs: [describe]

Design a test data strategy covering:
- How to generate the data (SQL scripts, data factories, API seeding)
- CSV structure and column names for JMeter / k6 feeders
- Data isolation between VUs (partition strategy)
- Cleanup strategy post-test
- Handling sensitive PII in test data

Provide sample CSV header rows and a data generation SQL or script snippet.

I am using a CSV file with [N] rows for [N] virtual users in JMeter.

The CSV contains: [list column names]

Configure JMeter CSV Data Set Config for:
- Scenario A: Each VU gets a unique row (no sharing)
- Scenario B: All VUs cycle through the same data pool
- Scenario C: Random access pattern

For each scenario provide:
- CSV Data Set Config XML
- Sharing mode recommendation
- What happens when EOF is reached
- Gotchas with thread count vs row count mismatch

Generate a JSR223 PreProcessor Groovy script that creates dynamic test data per iteration:

Required data:
- Unique email: user_[timestamp]_[threadNum]@test.com
- Random phone number: 10-digit US format
- Random date of birth: between 1970 and 2000
- UUID for correlation ID
- Random amount: between 10.00 and 999.99

Store each as a JMeter variable accessible via ${varName}. Add comments explaining each operation.