Answer Posted / prasant tripathy

Hi

star schema takes more space then the snowflake because
star schema is denormalised schema and snowflake is
normalised

What are the various tools? Explain name a few?

1024

---

What are the key columns in Fact and dimension tables?

1023

---

What is mean by aggregate aware?

1158

---

Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....

2379

---

Give some difference between oltp and olap.

1069

---

Explain a mapping, session, worklet, workflow, mapplet?

1152

---

What is MODEL is Data mining world?

2663

---

explain about balanced dimension,

1036

---

what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc

2543

---

Explain what is the main difference between inmon and kimball philosophies of data warehousing?

1027

---

What we will do with the universe for faster process?

1029

---

How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?

978

---

What are partition points?

1142

---

Explain the importance of data warehouse?

1065

---

What is difference between model & package?

1084

---