Answer Posted / sudheer.r

snowflake schema is centrally located fact table .and
surrounded by normalized dimension tables..
in snowflake compare to dimensions and ffact table
dimensions are small.dimensions are more compare to ster
chema .. snow flake shema very dificult to understand ...

How to reduce warnings?

945

---

How are the dimension tables designed?

1010

---

What is an error log table in informatica occurs and how to maintain it in mapping?

972

---

Explain the data type of the surrogate key?

956

---

What is pre-emptive and non-pre-emptive?

983

---

What is data warehouse architecture?

1054

---

Explain what are the tasks that loadmanger process will do?

933

---

for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?

2140

---

I need a good brd and uc template?

1094

---

How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?

928

---

What is the difference between a primary and secondary actor in use case modeling?

1071

---

Explain can report net connect multiple datasource at a time in report creation time?

939

---

Explain what are data marts?

1129

---

What are the advantages of query studio compared to report studio?

894

---

What is surrogate key? Where we use it? Explain with examples.

1038

---