Can we execute multiple SQL queries in single 'Veritca Request' component? What we have tried is to execute say 2 queries with 2 different Vertica request components. What we need to know if that can be done using single Vertica component.
Our requirement is to load test Vertica database with SQL queries of multiple datasets/reports which are present on a MicroStrategy dashboard. When dashboard executes then, all datasets/reports present on it get populated from database. Hence from database side what we need to do is say for 200 concurrent users/threads, if a dashboard has 10 datasets/reports, then we need to fire 10 different queries for 200 concurrent users all together and analyze results.