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 is the difference between olap and datawarehosue?
What is the function of etl when used in data warehousing?
Explain functional dependency?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
How can you set the client management?
What are the different types of data warehousing?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
What are the differences between star and snowflake schema?
i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????
What are aggregate tables and aggregate fact tables?
What according to you might be the future of data warehousing?
What is the difference between view materialized view and view?
What are cluster analysis in data warehousing?
How to import vsam files from source to target. Do we need a special plugin?
How can we load the time dimension?