Answer / venkat

In the aboue two (snow flake,star)schemas ,star schema is
best,because star schema is denormalised and star schema is
centrally located Fact table and surrounded by multiple
dimention tables.so fact table size can be calculated based
on the lowest level granularity of the dimentions.

Answer / koti

star schema is for simple data marts where as snowflake
schema for complexives...

Answer / senthil

hi
normally people using star schema in data warehousing
because it is de_normalized and easy way to retrieve data
from target and also understanding..
But snow flake is in fully normalized.normally OLTP
we use normalized ..

star schema used in data warehousing ..

Answer / radhakrishnansk

star schema is used for easy retrieval.
It is in 2nd normal form.
But snow flake is in 3rd normal form it needs more joins for
retrieval.

What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .

1 Answers  

---

Difference between STOP & ABORT in Informatica.

3 Answers   Accenture, Wells Fargo,

---

i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?

8 Answers   iNautix,

---

From where we can start or use pmcmd?

3 Answers  

---

Hi, Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9. Regards, Eva

1 Answers   Accenture,

---

what is the difference between static and dynamic

4 Answers   TCS, Wipro,

---

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

0 Answers  

---

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?

2 Answers   Span Systems,

---

When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?

3 Answers   IBM,

---

following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?

7 Answers   Polaris,

---

Explain about HLD and LLD ?

16 Answers   Accenture,

---

What is a design?

1 Answers  

---