Give some difference between oltp and olap.

0 Answers  

---

Disply the dname wise maximum salary

9 Answers   Principal Finance,

---

what are different ways of loading data to data warehouse using oracle?

1 Answers  

---

I know of using applysimple, but there are other ways too?

0 Answers  

---

Explain the different types of data warehousing?

0 Answers  

---

What is the difference between constraind base load ordering and target load plan?

0 Answers  

---

Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....

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,

---

Fact table is in normalized or de-normalized form?

0 Answers  

---

How to import vsam files from source to target. Do we need a special plugin?

0 Answers  

---

Can we take backup when the database is opened?

0 Answers  

---

Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?

0 Answers  

---