Answer Posted / ravi sadanand

Star Schema: It is fully denormalized schema.the diagram of
fact table with dimension tables resembles a star that's
why it is called star schema.All the dimensions will be in
2nd normal form.
Snow flow schema:In this all dimensions will be in
normalized form.that's why it is called normalized star
schema.For each attribut a seperate table will be
created.As there is a possibility for more number of
joins,obviously the performance will be degraded.

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5675

---

What is a joiner transformation?

996

---

What is sequence generator transformation in informatica?

1079

---

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2304

---

What is deployment group?

1215

---

Briefly describe lookup transformation?

1046

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2038

---

Explain the pipeline partition with real time example?

1144

---

What is the meaning of decode in informatica?

1122

---

How to open an older version of an object in the workspace?

1205

---

What are the main issues while working with flat files as source and as targets ?

1160

---

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.

2200

---

On which transformations you created partitions in your project?

1348

---

How can you validate all mappings in the repository simultaneously?

1371

---

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8223

---