Answer Posted / kranthi.kunta

Degenerate dimension: A column of the key section of the
fact table that does not have the associated dimension
table but used for reporting and analysis, such column is
called degenerate dimension or line item dimension.
For ex, we have a fact table with customer_id, product_id,
branch_id, employee_id, bill_no, date in key section and
price, quantity, amount in measure section. In this fact
table, bill_no from key section is a single value, it has
no associated dimension table. Instead of cteating a
seperate dimension table for that single value, we can
include it in fact table to improve performance.
SO here the column, bill_no is a degenerate dimension or
line item dimension.

Explain er diagram?

1038

---

Explain what is full load & incremental or refresh load?

1035

---

I need to set predefined condition. How I do this?

1067

---

What is the difference between Datawarehouse and OLAP?

975

---

Explain what is a view as it relates to system modeling?

1041

---

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

2379

---

in general which algorithms for used?

2075

---

How to create context?

1065

---

Explain what is the difference between view filter and report filter?

1037

---

What are the other names given to data warehousing?

1158

---

How many types of facts and what are they?

1060

---

How to export mappings to the production environment?

953

---

How can you set the client management?

1063

---

What is data warehouse architecture?

1100

---

What is analytical or analytic mean?

1189

---