Answer / Ashish

OLTP (Online Transaction Processing) is primarily used for transactional applications, where data is frequently modified and updates need to be made in real-time. OLAP (Online Analytical Processing), on the other hand, is designed for complex analysis of large datasets, typically involving aggregation, drilling down, and slicing and dicing of data. While OLTP focuses on fast insert, update, and delete operations, OLAP emphasizes fast query response times.

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

1 Answers  

---

What are the advantages of raid 1, 1/0, and

1 Answers  

---

Explain what are the advantages data mining over traditional approaches?

1 Answers  

---

What is MDX?

2 Answers   TCS,

---

Explain what are the various transformation available?

1 Answers  

---

Explain hybrid slowly changing dimension?

1 Answers  

---

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

0 Answers  

---

Explain the difference between data ware house & data mart?

1 Answers  

---

What is the difference between agglomerative and divisive hierarchical clustering?

1 Answers  

---

Explain the difference between filter and conditin?

1 Answers  

---

How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?

1 Answers  

---

suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?

3 Answers   Oracle,

---