Interested to Buy Any Domain ? << Click Here >> for more details...
wht is degenerated dimension ?it's uses?
- 10 Answers
- 52129 Views
- CTS, Infosys, I also Faced
- E-Mail Answers
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.
| Is This Answer Correct ? | 99 Yes | 6 No |
Post New Answer View All Answers
a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron
Explain the difference between data ware house & data mart?
What is the goal of optimizer?
Database in use is oracle?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
Where the cache files stored?
What is the 4 + 1 view model as it relates to system modeling?
What are components of report studio?
What is Discrete and Continuous data in Data mining world?
What are the various file formats involved in reportnet?
How to pivot data using informatica when you have variable amount of pivot rows?
Explain me what is vldb?
What are the possible data marts in retail sales?
What is difference between e-r modeling and dimensional modeling?
What is perform recovery?
