How many ways we test the universe & Report?
Answers were Sorted based on User's Feedback
Answer / smita chatterjee
There are some basic ways of testing the universe:
1. built in feature of check integrity and 5 other check options which check for parsing, looping, context etc.
2. The other way of checking whether a universe is properly working is by creating dummy report and verifying with the back end data.
The method of testing reports is :
1. Data checking: where we tally the report data with the database data by help of the database client like sql server or toad which can aid to check the underlying data whether the source is JDE or Terradata or DB2 or Oracle.
2. Integration Testing where we insert or update data from an UI and then check the impact on our report.
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / guest
By doing check integrity we can test universe & By coping
report query and run in back end(oracle,sql server...) we
can test the data by comparing both.
| Is This Answer Correct ? | 2 Yes | 6 No |
What are the methodologies of data warehousing?
What are target types on the server?
Whether dimension table can have numeric value?
How can you set the client management?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What are fact, dimension, and measure?
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
Explain what are non-additive facts?
Explain why are oltp database designs not generally a good idea for a data warehouse?
difference between For each and for all
What is real-time datawarehousing?
explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF ORACLE 8I
3 Answers IBM, Ness Technologies,