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.

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.

If your client approaches you and says that he wants to create a Datawarehouse, and provides just the info regarding his source systems. What are all the neccessary actions one is supposed to take/understand and get back with a comprehensive document which convinces the client to proceed with the DW initiative. What are all the documents we need to provide the client?

1 Answers   CSC,

---

Why fact table is in a normal form?

0 Answers  

---

how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause

0 Answers   iGate,

---

How to performance tune reports?

0 Answers  

---

What is application.cfm?

0 Answers  

---

what are the others of "bad files" and "discard files" when using sql*loader?

0 Answers  

---

what is indexing ? what are different types of indexes supported by oracle ?

2 Answers  

---

Define data warehouse?

0 Answers  

---

What is factless fact schema?

2 Answers  

---

What are the advantages and disadvantages of reporting directly against the database?

0 Answers  

---

What are parallel querys and query hints?

0 Answers  

---

Explain degenerate dimension table?

0 Answers  

---