Answer Posted / santosh

According to Ralph Kimbal, in a data warehouse, a degenerate dimension is a dimension which is derived from the fact table and doesn't have its own dimension table. Degenerate dimensions are often used when a fact table's grain represents transactional level data and one wishes to maintain system specific identifiers such as order numbers, invoice numbers and the like without forcing their inclusion in their own dimension. The decision to use degenerate dimensions is often based on the desire to provide a direct reference back to a transactional system without the overhead of maintaining a separate dimension table.

Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

1971

---

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.

1088

---

What are templates in which way it is help full?

994

---

What are vaious etl tools in the market?

999

---

What is data mart in data warehouse?

945

---

Can you state some of the innovations throughout history?

975

---

Store (and count) non-fact records?

924

---

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

986

---

Why should we use data ware housing and how can you extract data for analysis with example?

994

---

What is a core dimension?

1065

---

What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

1070

---

What are the different models used in cluster analysis?

956

---

Explain which columns go to the fact table and which columns go the dimension table?

924

---

Explain datawarehousing?

1042

---

What is partitioning? What are the types of partitioning?

1160

---