Answer / arun

Star schema has less joins within its related dimensions so query retreival is faster than SNow-flake.

Space consumed is more than snow-flake

Answer / jz

1) Query performance is high.
2) It consume less space compare to SnowFlake.

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

4 Answers   Magna Infotech,

---

CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?

6 Answers  

---

What is a sorter transformation?

0 Answers   Informatica,

---

How you can differentiate between connected lookup and unconnected lookup?

0 Answers  

---

What's the layout of parameter file (what does a parameter file contain?)?

0 Answers   Cognizant,

---

Hi experts, can anyone tell how much we use plsql in real time

3 Answers  

---

what are the limitations of pushdown optimization technique ? Advance thanks

3 Answers   Puma,

---

What is the approximate size of data warehouse?

6 Answers   Accenture, i3 Solutions,

---

Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

2 Answers   NTT Data,

---

What is incremental aggregation?

0 Answers  

---

following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?

2 Answers   Patni,

---

What is the maplet?

0 Answers   Informatica,

---