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.

After the generation of a report to whom we have to deploy or what we do after the completion of a report?

863

---

what is parallel query?

2028

---

What is a core dimension?

1014

---

What is a staging area? Do we need it? What is the purpose of a staging area?

942

---

How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?

953

---

Explain what are the modules in power mart?

972

---

"A dimension table is wide but the fact table is deep," explain the statement in your own words.

1306

---

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?

882

---

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

1925

---

Explain what is a staging area? Do we need it? What is the purpose of a staging area?

902

---

Explain what are the various methods of getting incremental records or delta records from the source systems?

914

---

What is fact less fact table? Where you have used it in your project?

927

---

What is cost benefit analysis (cba)?

939

---

What are Aggregate tables?

1105

---

How can we determine what records to extract?

1029

---