Answer Posted / nethaji

We use star schema when the query involves few joins and for
better performance.here data is denormalized.
Snow-flake schema is an extension of star where the
dimensions are divided into hierarchy of dimensions.eg: time
dimension.
time->year->month->day
For complex joins we go for snow-flake.performance is little
bit slower due to no. of joins.Here data is normalized.

What is data analytics in simple terms?

1082

---

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

946

---

What is partitioning? What are the types of partitioning?

1073

---

What are various warehousing tools?

918

---

What according to you might be the future of data warehousing?

940

---

Explain what is analytical or analytic mean?

959

---

How to performance tune reports?

1044

---

Explain reference cursor?

2113

---

What we will do with the universe for faster process?

922

---

Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.

854

---

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

1151

---

What is static and local variable?

979

---

What are the differences between datamart vs. Reporting cube?

1032

---

What is a functional dependency f said to be minimal?

981

---

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

876

---