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
- 4485 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 |
What is Indexing? how did u implement indexing?
Can any one tell me for business objects what we need to study means some body tole me that we need DW,ETL,SQL.... is this is necessary..?
There are two options to set "max number of rows fetched" from designer, 1. Tools> Options 2. From universe parameters What is the different between these two and why their valus are different?
what is the difference btween olap and oltp?
How do u get requirement from the client? in what format?
Explain about derived tables?
What is DSS?? (Defination of DSS)
Hi, In BO at universe designer i had four tables which has many to many relationships between the tables. How to fetch the correct results in the report?
In a column if the value is >10000, it has to show downwards Arrow in green color, If the value is <10000, it has to show upwards arrow in red Color.... How to achieve this?
Can anybody tell me the difference b/w canned and adhoc reporting?.
How can we acheive Correlated sub-query in Designer?
2 Answers Infosys, TCCX, Wells Fargo,
Ihave one report.Now i want to display that report as one row as one color and another row as another color.The entire report i need like that
Teradata 
