Answer Posted / gattu srinivasarao
FactTable:It consists of th efacts and references of the diminision tables.
Diminsion table:It consists only charchter values,for example cus_name,cus_add,etc..
Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
Explain what is the difference between datawarehouse and bi?
What is meant by metadata in context of a data warehouse and how it is important?
What is the main difference between star and snowflake star schema? Which one is better and why?
What are the different ways to represent the loading of dimension tables?
What are the different methods of loading dimension tables?
How to drill through from a powerplay cube to reportnet?
How to generate the cubes in framework manager?
Define Data Warehousing?
Explain how to export mappings to the production environment?
What is data warehosuing hierarchy?
what is difference between drill & scope of analysis?
Why should we use data ware housing and how can you extract data for analysis with example?
Explain difference between data ware house & data mart?
How to limit the max no of rows retrieved in the report?
Explain the difference between keylokup and joiner?