Answer / Sanjeev Gupta

Application.cfm is the main entry point for a ColdFusion application. It contains initialization code, sets up request variables, and includes other required components.

What is surrogate key? Where we use it explain with example?

1 Answers  

---

What is freehand sql?

1 Answers  

---

How can Oracle Materialized Views be used to speed up data warehouse queries?

3 Answers  

---

Tell me the Top 10 features of oracle that supports datawarehousing.

2 Answers   CTS, IBM,

---

If two relational tables are connected to sq trans, what are the possible errors it will be thrown?

1 Answers  

---

Explain why are oltp database designs not generally a good idea for a data warehouse?

1 Answers  

---

Code the tables statement for a single-level (most common) frequency?

1 Answers  

---

Explain what are the advantages data mining over traditional approaches?

1 Answers  

---

Explain difference between data ware house & data mart?

1 Answers  

---

Explain the difference between dw and bi?

1 Answers  

---

what is table partitioning? How it is useful to warehouse database?

1 Answers   EDS, IBM,

---

What are the data marts?

1 Answers  

---