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 an unconnected transformation?

1 Answers   Informatica,

---

What is the function of aggregator transformation?

1 Answers  

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

1 Answers   iGate,

---

Kimball and Inmon methodologies?

2 Answers  

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1 Answers  

---

tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?

3 Answers   IBM, Patni, TCS,

---

If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks

7 Answers   Puma,

---

What do think which one is the better joiner or look up?

1 Answers  

---

What are the basic needs to join two sources in a source qualifier?

3 Answers  

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1 Answers   IBM, TCS,

---

what is lookup chache?

1 Answers   Patni,

---

What is depict expression change?

1 Answers  

---