Last Updated
Viewed 2,044 Times

I have downloaded the DSGEN tool from the TPC-DS web site and already generated the tables and loaded the data into Oracle XE.

I am using the following command to generate the SQL statements :

dsqgen -input ..\query_templates\templates.lst -directory ..\query_templates -dialect oracle -scale 1

However, No matter how I adjust the command I always get this error message :

ERROR: A query template list must be supplied using the INPUT option

Can anybody help?

Similar Question 1 : TPC-DS queries generator

I need to test my data warehouse using TPC-DS. How can I generate queries for my data warehouse using TPC-DS? I tried to generate but it generate for a specific data warehouse.


What are some of the common benchmarks other than TPC-H and TPC-DS, that involve many large fact tables and multiple joins over them ?

I want to generate the TPC-DS data (1 TB and 10 TB) directly in AWS S3 without transferring from local machine to s3. What is the easiest way to do that?

Similar Question 4 (1 solutions) : How do I compare two SQL queries to run on Postgres

Similar Question 5 (1 solutions) : How to compute a conditional percentile in Oracle SQL

Similar Question 6 (2 solutions) : How to calculate accumulated sum of query timings?

Similar Question 7 (1 solutions) : How do you repeat a raw SQL query # times to MySQL?

Similar Question 8 (2 solutions) : Generating TPC-DS database for sql server

Similar Question 9 (1 solutions) : How to obtain benchmark data (TPC-H)