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
Explain what are the various reporting tools in the market?
Which columns go to the fact table and which columns go the dimension table?
How do we design a universe?
Explain when do we analyze the tables? How do we do it?
Explain what does level of granularity of a fact table signify?
How to get the first 100 rows from the flat file into the target?
How are models actually derived?
How to calculate fact table granularity?
Tell me what is full load & incremental or refresh load?
What is an er diagram?
Database in use is oracle?
How to load the time dimension?
Explain what is the difference between a primary and secondary actor in use case modeling?
How do you define data block size?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?