how to test the reports if there are multiple sql
statements?i,e if there is 1 single sql statement we can
copy it and paste it in TOAD or someother tools to test it
but if we have multiple sql statements in a single query????



how to test the reports if there are multiple sql statements?i,e if there is 1 single sql statemen..

Answer / shamanth

Should be clear what meant by multiple SQL staements ?

We can take the multiple SQL stmts and paste them to TOAD
and test.
When WEBI generate multiple SQL stmts(Combined
Queries),those should be either Union,intersect etc...so
the same will be applicable for TOAD also...

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Business Objects Interview Questions

how to limit number of rows in a report in business objects using webi?

3 Answers   Cap Gemini, TCS,


Once the project is submited to the Client. Client says that report is taking long time to run? Where u need to check?

2 Answers   Wipro,


What is the use of linling the universes?Thanks in advance

2 Answers  


I have 2 tables. Table 1 is employee table and Table2 is department table. In employee table i have 1,2,3,4,5 emp id's,in Dept table i have various dept's like a,b,c and i have 2,3,4 emp id's in my dept table.I joined with these 2 tables.I want the results for equi join means how many records will fetch.In the same scenario i have to know the left outer join, right out join and full outer join resuls means how many records will come. can any body tell me the answers

1 Answers   IBM,


it is possible to link two universes of separate functional domain ?

1 Answers   IBM,






IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?

1 Answers   Accenture,


how do you share the universe ?

4 Answers   Tech Mahindra,


What is meant by ZABO and FC(full-client)?

2 Answers  


How many tables can an universe contain is their any limit to insert tables in the universe?

3 Answers  


how do you give security to universe ?

2 Answers   InfoStep, Tech Mahindra,


When N reports are scheduled for N users, How does the BCA process /know to which user the report needs to be sent?

4 Answers   Wipro,


what r the main topics to prepare for the crystal reports? could any on help me? i want to preparing for the interviews? and also send any pdf file?

1 Answers   TCS,


Categories