Answer Posted / harsh sugandhi

select dname, max(sal) from dept group by dname;

Explain what are the different methods of loading dimension tables?

992

---

What is cost benefit analysis (cba)?

1041

---

How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?

1053

---

Explain difference between data ware house & data mart?

1028

---

if you use oracle sql*loader , how do you transform data with it during loading?

2140

---

Explain a mapping, session, worklet, workflow, mapplet?

1147

---

Which columns go to the fact table and which columns go the dimension table?

1019

---

Explain what is cost benefit analysis (cba)?

1018

---

What is surrogate key? Explain with examples.

1221

---

What is the definition of cube in datawarehousing?

1038

---

How can we run the graph? What is the procedure for that?

990

---

Explain difference between e-r modeling and dimentional modeling?

1034

---

What is index awareness in universe?

1088

---

Code the tables statement to produce a multi-level frequency?

1045

---

What are the methodologies of data warehousing?

1035

---