Answer Posted / divya

SELECT d.dname,max(e.sal) from emp e,dept d where e.deptno=d.deptno
group by d.dname

What is execution plan?

1155

---

Explain what does level of granularity of a fact table signify?

900

---

explain about dirty dimension?

1070

---

Explain what is real time data-warehousing?

1046

---

What is core dimension?

993

---

What is a general purpose scheduling tool?

1021

---

Explain what is full load & incremental or refresh load?

934

---

Explain what are components of reportnet?

901

---

Explain what is the limit to the number of sources and targets you can have in a mapping?

944

---

Why denormalization is promoted in universe designing?

943

---

How can you implement many relations in star schema model?

935

---

Explain can report net connect multiple datasource at a time in report creation time?

869

---

What are the different types of join operations?

934

---

What is the difference between filter and lookup transformation?

1021

---

What is data analytics in simple terms?

1077

---