Interested to Buy Any Domain ? << Click Here >> for more details...
wht is degenerated dimension ?it's uses?
- 10 Answers
- 52087 Views
- CTS, Infosys, I also Faced
- E-Mail Answers
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 surrogate key? Where we use it?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
What is type 2 version dimension?
What are the key columns in Fact and dimension tables?
Explain what is data validation strategies for data mart validation after loading process?
What is is a star schema?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
if you use oracle sql*loader , how do you transform data with it during loading?
What is the metadata extension?
What is surrogate key? Explain with examples.
What is Sequence clustering algorithm?
what is user variable in affinium campaign? and some real time examples.
What are the design methods of data warehousing?
What are the steps involved in creating dimensional modeling process?
What are the different types of schemas used in data warehousing?
