What are Fact tables and Dimension Tables?

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


Please Help Members By Posting Answers For Below Questions

Explain what is the difference between datawarehouse and bi?

603


What is meant by metadata in context of a data warehouse and how it is important?

750


What is the main difference between star and snowflake star schema? Which one is better and why?

635


What are the different ways to represent the loading of dimension tables?

587


What are the different methods of loading dimension tables?

640






How to drill through from a powerplay cube to reportnet?

583


How to generate the cubes in framework manager?

625


Define Data Warehousing?

827


Explain how to export mappings to the production environment?

634


What is data warehosuing hierarchy?

670


what is difference between drill & scope of analysis?

611


Why should we use data ware housing and how can you extract data for analysis with example?

639


Explain difference between data ware house & data mart?

608


How to limit the max no of rows retrieved in the report?

628


Explain the difference between keylokup and joiner?

581