what is degenerated dimension table with scenario
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
What is the difference between informatics 7x and 8x and what is latest version?
What are the differences between oltp and olap?
Why update strategy and union transformations are active?
Explain direct and indirect flat file loading (source file type) - informatica
Can we get 1st record through Informatica(without sequence number).
How to load the data from people soft hrm to people soft erm using informatica?
Can anyone tell me the new features in Informatica 9 Version?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Could you explain what is enterprise data warehouse?
What is the meaning of up gradation of repository?
What is a code page?
Why union transformation is an active transformation?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What are connected or unconnected transformations?