Interested to Buy Any Domain ? << Click Here >> for more details...
what is degenerated dimension table with scenario
- 2 Answers
- 3679 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 does “tail –f” command do and what is its use as an Informatica admin.
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What are the different options available for update strategy?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Mention few advantages of router transformation over filter transformation.
What are the static cache and dynamic cache in informatica?
Informatica settings are available in which file?
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
Design a mapping to load the cumulative sum of salaries of employees into target table?
Explain the different lookup methods used in informatica?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How to create Target definition for flat files?
How do you load unique records into one target table and duplicate records into a different target table?
Can you generate sequence numbers without using the sequence generator transformation?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
