Answer Posted / mallik
The method specified above is a good technique.
The procedure below may add adequate value to the testing
the method descibed above.
First idetify the source tables based on the design
specifcation for the report, then verify that the right
tables/schema are selected as source(s) of the report, then
comes the condition(business rules transformation rules
etc) check using join conditions. If tester is able to
write a complex query himself (in many cases it may not be
fasibel to have person with that level of sql expertise)
and then verify for discrepancies. next comes the query
efficiency (optimisation) etc and finally the formatting
verification
The first step serves as analysis/design verification step
to detect in detecting analysis and design defects early
and helps in avoiding unnecessary test execution effort.
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
When we use aggregate awareness function in designer?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
Can we create universe with no cache??
Which versions are used in the bo dashboard work?
Explain the difference between union and group?
What is difference between custom hierarchy and report based hierarchy?
What three things do you consider to be the most important factors for a manager?
Explain how to schedule the report in b.o?
How to create Index to the table in the universe designer and how it improves the Query performence
What is aggregate table and aggregate fact table ... Any examples of both?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
explain in detail about type 3?
How to open a universe with out using the Designer ??
Explain how to execute the plsql procedure from the report by clicking with mouse?
Which command using Query Analyzer will give you the version of SQL server and operating system ?