Interested to Buy Any Domain ? << Click Here >> for more details...
How many ways we test the universe & Report?
- 2 Answers
- 6121 Views
- I also Faced
- E-Mail Answers
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 is the difference between OLAP, ROLAP, MOLAP and HOLAP?
Explain bus schema?
What is surrogate key? Where we use it?
What is data validation strategies for data mart v?
What is surrogate key? Explain with examples.
What is incremintal loading?
Explain the main difference between inmon and kimball philosophies of data warehousing?
How to calculate fact table granularity?
What are the different ways to represent the loading of dimension tables?
Explain what is the difference between olap and datawarehosue?
What is the difference between a data warehouse and a data mart?
15 Answers Apex, ASD Lab, Bank Of America,
Explain what are the vaious etl tools in the market?
Teradata 
