How many ways we test the universe & Report?

Question Posted / guest

2 Answers
6200 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How many ways we test the universe & Report?..

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

How many ways we test the universe & Report?..

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

Post New Answer

More Data Warehouse General Interview Questions

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?

0 Answers

I HAVE A FLAT FILE DO THE NULL CHEK AND PRIMARI KEY CHEK AND DATE VALIDITAION LOAD TO TARGET TABLE

1 Answers Wipro,

How can we do ETL process in SQL Server?

1 Answers ETL,

Explain what is ods (operation data source)?

0 Answers

What is Operational Data Store?

0 Answers Informatica,

Explain some of modeling tools available in the market?

0 Answers

What are session timeout and application timeout? Where we have to do this process?