What is degenerate dimension table?
- 1 Answers
- 1090 Views
- I also Faced
- E-Mail Answers
Answer / Bahoran Singh
"A degenerate dimension table is a dimension table with only one column, usually the primary key of a fact table. It is used when there is no need for additional attributes or categories to be associated with the fact data."
| Is This Answer Correct ? | 0 Yes | 0 No |
Can you explain how analysis service works?
What is factless fact tables?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
what are the others of "bad files" and "discard files" when using sql*loader?
What are aggregate fact tables ? why they are needed? give an example
Explain what is the difference between stop and abort?
What are the different types of data warehouses?
5.Explain ODS ?
Explain what are fact, dimension, and measure?
How can you clear the cache?
Explain what is the extension of file to save template?
What is surrogate key? Where we use it explain with example?
Teradata 
