Interested to Buy Any Domain ? << Click Here >> for more details...
what is degenerated dimension table with scenario
- 2 Answers
- 3632 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / bhavemanali10
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 |
Post New Answer View All Answers
What is olap (on-line analytical processing?
Why update strategy and union transformations are active?
What is the session task and command task?
Why is sorter an active transformation?
can u any challenge your project?
How to handle decimal places while importing a flatfile into informatica?
Can you use flat files in Mapplets.
Scheduling properties,whats the default (sequential)
What is data transformation manager process?
Name the different lookup cache(s)?
Whats the difference between informatica powercenter server, repositoryserver and repository?
How do you use reject loader.
in reporting we add some new objects,how we get the count of the newly added objects to the report
differences between service based and product based?
What is repository manager?
