Answer Posted / nethaji
There are many dimension tables.
The commonly used are
Confirmed dimension,
Junk dimension,
Degenerated dimension,
Slowly changing dimension,
Rapidly changing dimension
The others are
Virtual dimension,
Regular dimension,
Casual dimension,
Shared dimension,
monster dimension.
These are used on certain condtions.
| Is This Answer Correct ? | 28 Yes | 15 No |
Post New Answer View All Answers
What is the difference between connected and unconnected stored procedures?
Explain what is fact less fact table? Where you have used it in your project?
Why we use repository connectivity?
How to pivot row data using informatica?
What is a real-time data warehouse?
What are the advantages of cold fusion?
Explain what is the difference between view filter and report filter?
What is Star Schema?
Explain which columns go to the fact table and which columns go the dimension table?
What is an er diagram?
What needs to be done when the database is shutdown?
How are models actually derived?
Explain hybrid slowly changing dimension?
What is difference between query studio and report studio?
Where we use surrogate key explain with example?