Generating Test Data in Teradata

Database
Enthusiast

Generating Test Data in Teradata

Hi,

I am trying to build some case studies to document the different Query plans for various queries executed on huge tables.

Does any one has a way to generate some Test data in millions in a set of tables ??

Thanks
Manik
1 REPLY
Enthusiast

Re: Generating Test Data in Teradata

You can do these but you need to have all the test data for the required fields in a file.

You can do these through BTEQ IMPORT or through Teradata SQL Assistant by using the import option.