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.

How many input parameters can exist in an unconnected lookup?

0 Answers  

---

what is session parameters?

1 Answers   Cap Gemini,

---

what is target update override and when we use it?

2 Answers   TCS,

---

What is best approach to load 100 different source files (Different structure) to differet target tables ?

2 Answers   IBM, TCS,

---

 Code page compatibly –Where all changes are made to handle the scenario.

1 Answers   DELL,

---

---

What is the difference between view and materialised view?

6 Answers  

---

while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile

2 Answers   Amdocs,

---

my source is junk data how will u remove that junk data by using unix please any one replay me

0 Answers   Cap Gemini,

---

Differentiate between source qualifier and filter transformation?

0 Answers  

---

Tell me about informatica architecture.

2 Answers   TCS,

---

How many ways are there to do 'remove duplicate records in informatica'?

0 Answers  

---

Why should we use star schema in datawarehouse design?

2 Answers   Wipro,

---