Interested to Buy Any Domain ? << Click Here >> for more details...
what is degenerated dimension table with scenario
- 2 Answers
- 3677 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
explain about unit testing? in real time?
What is a joiner transformation and why it is an active one?
How do you load first and last records into target table?
Tell me about MD5 functions in informatica
How we can create indexes after completing the load process?
What is mapping debugger?
How to use procedural logic inside infromatica?
What are the types of schemas we have in data warehouse and what are the difference between them?
What are the tuning techniques you applied during your last project
Is it possible to revert a global repository to local one and why?
What is session task and command task?
Explain the types of transformations?
What is an expression transformation in informatica?
What is deployment group?
How to Create a folder using pmrep command?
