Answer / Akshay Vivek

The statement 'A dimension table is wide but the fact table is deep' means that a dimension table tends to have many columns (wide) representing attributes or characteristics of the entities, while a fact table tends to have many rows (deep) recording the measurements or facts about those entities. In other words, dimensions provide context to the facts recorded in the fact table.

What are situations where snowflake schema is better than star schema when the opposite is true?

1 Answers  

---

What are data modeling and data mining?

1 Answers  

---

What are the types of partitioning?

1 Answers  

---

hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

1 Answers   L&T,

---

Can decision tree be implemented using SQL?

1 Answers  

---

What is a look up function? What is default transformation for the look up function?

1 Answers  

---

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

1 Answers  

---

What is freehand sql?

1 Answers  

---

i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????

1 Answers   Wipro,

---

What are the steps of implementing data warehousing?

1 Answers  

---

What is the difference between agglomerative and divisive hierarchical clustering?

1 Answers  

---

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

1 Answers  

---