what is degenerated dimension table with scenario
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
How to update source definition?
How can you define user defied event?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How to elaborate powercenter integration service?
How to generate sequence numbers using expression transformation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Explain load alternative records / rows into multiple targets - informatica
Scheduling properties,whats the default (sequential)
Explain transaction control transformation in informatica
Write the prerequisite tasks to achieve the session partition?
What is the difference between STOP and ABORT options in Workflow Monitor?
How to start a workflow using pmcmd command?
What are pre and post-session shell commands?
Where do we use mapping variables in informatica?
In development project what is the process to follow for an etl developer from day1