Answer Posted / gyana ranjan behera

SELECT DNAME,MAX(SAL) FROM DEPARTMANT_TABLE GROUP BY DNAME

Explain what are the advantages data mining over traditional approaches?

1082

---

Explain the main difference between inmon and kimball philosophies of data warehousing?

921

---

how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause

2086

---

What is conformed fact?

1040

---

What is many-to-many dimensional model in datawarehousing ?

872

---

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

2032

---

Explain me what are data marts?

1004

---

What is hybrid slowly changing dimension?

987

---

Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?

876

---

What is data warehosuing hierarchy?

1053

---

What is factless fact tables?

1114

---

What is data stream and data adaopter?

1022

---

What are vaious etl tools in the market?

938

---

Explain the data type of the surrogate key?

902

---

How to get the first 100 rows from the flat file into the target?

1151

---