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.

Can decision tree be implemented using SQL?

0 Answers  

---

5.Explain ODS ?

3 Answers   HCL,

---

What is operational data source (ODS)?

2 Answers  

---

i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????

0 Answers   Wipro,

---

What is "method/1"?

0 Answers  

---

Explain what are non-additive facts?

0 Answers  

---

Hi Guys, I have been to L& T last week ..Please find the questions mentioned below 1)Slowly changing dimension types 2)DML statement 3)DDL statement 4)write a syntax to create database 5) differences between count(*) and count(column) 6) differences between union and union all 7) what is decode 8) what is NVL 9) Arrange the values in ascending order 10,5,20,15,null 10)Primary and surrogate key 11)what is group by clause does? 12)what is difference between truncate and delete 13)what is difference between OLAP and OLTP ? 14)Architecture of Datawarehouse 15)how do you test the data validation from source as (flat file and xml) to staging tables. 16)what is shedule and time bound the mentioned above question asked in two rounds.all the best

2 Answers   L&T,

---

What is surrogate key? Where we use it? Explain with examples.

0 Answers  

---

How do you create surrogate key using ab initio?

0 Answers  

---

How many ways we test the universe & Report?

2 Answers  

---

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

2 Answers  

---

Why fact table is in a normal form?

0 Answers  

---