Answer Posted / vensh
Dimension table is nothing but a table which contains detailed description about the data except any values...
Fact table mainly contains the facts nothing but the values that is related to the data in the dimension table and by using the primary key in dimension table and the foreign key in the fact table we will map the dimensional table and the fact table
Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
How to export mappings to the production environment?
Explain normalization?
Why we use repository connectivity?
What needs to be done while starting the database?
What is the difference between agglomerative and divisive hierarchical clustering?
How can you set the session management?
How can you clear the cache?
What are the data types present in bo?
Explain why should you put your data warehouse on a different system than your oltp system?
What are algorithms provided by Microsoft in SQL Server?
How to calculate fact table granularity?
What are aggregate transformation?
How to import vsam files from source to target. Do we need a special plugin?
What is aggregate fact table?