Answer Posted / 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 |
Post New Answer View All Answers
What are the different types of fact tables used in data warehousing?
What is Star Schema?
Who needs data warehousing?
What is surrogate key? Where we use it? Explain with examples.
What is analytical or analytic mean?
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
The same tier?
Explain how to export mappings to the production environment?
How to import vsam files from source to target. Do we need a special plugin?
I need to set predefined condition. How I do this?
What are the other names given to data warehousing?
What are the various transformation available?
explain about balanced dimension,
What is the difference between power center and power mart?
What is the difference between static cache and dynamic cache?