Answer Posted / kvchowdary

degenerate dimension is a data dimension that is stored in
the fact table rather than a separate dimension table. This
eliminates the need to join to a dimension table. You can
use the data in the degenerate dimension to limit or 'slice
and dice' your fact table measure

What is operational data store (ods)?

1017

---

Explain what are the modules in power mart?

1051

---

What are the methodologies of data warehousing?

992

---

What is drilling across?

994

---

what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.

2238

---

Explain how are the dimension tables designed?

1060

---

what are different storage options supported by oracle ?

2091

---

What are vaious etl tools in the market?

1004

---

Can we have multiple application.cfm file in an application?

955

---

What is data warehouse architecture?

1047

---

What is the use of dimensional modeling in data warehousing?

986

---

what is an use case?

1031

---

Can any one explain the hierarchies level data warehousing.

992

---

Explain datawarehousing?

1044

---

if you use oracle sql*loader , how do you transform data with it during loading?

2100

---