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.

What are the possible data marts in retail sales?

999

---

Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?

959

---

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?

937

---

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

981

---

Explain differences between star and snowflake schemas?

1158

---

Explain what are the different methods of loading dimension tables?

956

---

How to add a number to a macro variable?

993

---

What are the reasons to use a chameleon method in data warehousing?

1057

---

Explain which are the olap tools available that are supported by oracle?

1009

---

what is user variable in affinium campaign? and some real time examples.

4182

---

Why should you put your data warehouse on a different system than your oltp system?

976

---

What are session timeout and application timeout? Where we have to do this process?

1045

---

Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.

1985

---

What is bi?

1096

---

How much data hold in one universe.

994

---