Answer Posted / krishna

in starschema the fact is denormalised ...all dimension
tables are normalise..there will be primary foreignkey
relation ship between fact and dimension tables.
for better perfomance we use starschema when compare to
snow flake schema ..where fact table and dimension tables
are normalised...for every dimension table tthere will be a
look table ..we have to dig from top to bottom in the
snowflake schema.

Mention a few design and development best practices for informatica?

980

---

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1888

---

difference between repository database and repository service?

1135

---

What is the use of transformation?

986

---

what is song in infrmatica...?

2223

---

How many ways are there to create ports?

1309

---

How can you increase the performance in joiner transformation?

1181

---

What is the use of an aggregator cache file?

1182

---

How many dimensions are there in informatica?

1068

---

What is powercenter on grid?

1168

---

Explain joiner transformation in informatica

1112

---

What is domain and gateway node?

1155

---

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2042

---

What is Cognos script editor?

4206

---

How can you validate all mappings in the repository simultaneously?

1355

---