test data generator that supports vertica
does anyone know or used tools to generate test data that meets the following requirements
1. generates test data that meets business requirements ( i.e use the custom values for columns whereever we need business specific values , distribution etc ) . one example can be - if there is a status column , that values to use while generating data and what distribution to use for each value.
2. generate csv's with custom delimiter