what is degenerated dimension table with scenario
Answers were Sorted based on User's Feedback
Answer / 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 |
It is a dimension field in the fact table that doesn't have a corresponding dimension table. As a result - a degenerate dimension will use the field as key, name and its only attribute.
Degenerated dimension can be used to link back to the source as it is a natural key of the "parents" of the line items. It is used in reporting. Degenerate dimensions commonly occur when the fact table's grain is a single transaction. Although there is no corresponding dimension table of attributes, degenerate dimensions can be quite useful for grouping together related fact tables rows.
e.g.In health care, degenerate dimensions can group the claims items related to a single hospital stay or an episode of care
Is This Answer Correct ? | 0 Yes | 0 No |
What is data merging, data cleansing and sampling?
Examples of Fatal & Non-Fatal error?
Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks
How many ways are there to create ports?
what is constraint based loading
what is hash table in informatica?
A session S_MAP1 is in Repository A. While running the session error message has displayed
What is a filter transformation and why it is an active one?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
How to handle changing source file counts in a mapping?
Reusable transformation and shortcut differences
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?