wht is degenerated dimension ?it's uses?
Answer Posted / kvchowdary
degenerate dimension is a data dimension that is stored in
the fact table rather than a separate dimension table. This
eliminates the need to join to a dimension table. You can
use the data in the degenerate dimension to limit or 'slice
and dice' your fact table measure
| Is This Answer Correct ? | 13 Yes | 7 No |
Post New Answer View All Answers
What is pre-emptive and non-pre-emptive?
what are the other factors of the database on which the loading performance depend?
What is hybrid slowly changing dimension?
How to load the time dimension?
How to export mappings to the production environment?
How to get the first 100 rows from the flat file into the target?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
What is a functional dependency f said to be minimal?
How can you set the client management?
What is informatica architecture?
What are the various file formats involved in reportnet?
What are the data marts?
Why is business intelligence (bi) important in data warehousing?
Explain what is ods (operation data source)?