Interested to Buy Any Domain ? << Click Here >> for more details...
what is degenerated dimension table with scenario
- 2 Answers
- 3639 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / sruthi
Dimension which has only a single attribute. This dimension is typically represented as a single field in a fact table.The data items thar are not facts and data items that do not fit into the existing dimensions are termed as Degenerate Dimensions.
In below Fact Table with customer_id, product_id, bill_no, date in key section and price, quantity in measure section. In this fact table, bill_no from key section is a single value, it has no associated dimension table. Instead of creating a separate 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 ? | 1 Yes | 0 No |
Post New Answer View All Answers
can u any challenge your project?
What do you understand by SOA of Informatica?
What are the differences between a connected lookup and unconnected lookup?
What are the modules in Power Center
Explain constraint based loading in informatica
What are batches?
What is the benefit of partitioning a session?
How can we use mapping variables in informatica? Where do we use them?
How to elaborate tracing level?
What is meant by target load plan?
What is event and what are the tasks related to it?
Where is metadata stored?
How do you load only null records into target?
What is meant by query override?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
