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????
- 1 Answers
- 4572 Views
- IBM, I also Faced
- E-Mail Answers
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 |
Explain what are the steps to be taken to schedule the report?
WHAT ARE THE TYPES OF UNIVERSES?PLZ EXPLAIN IT
9 Answers Business Intelligence Analytics, SRA,
what are they different types of report in BO?
hi my question is in a report table how can we write table header without using of individual cell.can we merge column cells togrther??
What are the major problems will occur while migrating to the one version to another version?
IN BO I HAVE DATASOURCE HAVING THE DATA LIKE "abc" and after creating the Report that is unmathed data like "DEF".what will you do ?
generally how do we get information for creating universes and reports
If any one Deleted the BOMain key by accidently,is any possible to get back that Bomain key.if possible please send some steps.
I am trying to save the XI report to CSV format. the csv file not displaying columns in order. all the columns are misplaced. the report size is 12MB Can any one tell me why the columns are incorrect position when XI report converted into CSV format?
What are the general issues in migration process?
What is the use of Surrogate Key in BO?
When we are going for Shortcut join and why.
Teradata 
