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

Who needs data warehousing?

562


Explain why dimenstion tables are denormalized in nature?

516


Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?

576


Can we start and stop single session in concurent bstch?

532


What are the various transformation available?

570






I have two universes created by two difference database can we join them in designer & report level? How

534


How can we do data cleaning?

587


What is Active Datawarehousing?

577


What is a view as it relates to system modeling?

590


What is Operational Data Store?

602


What is a cube in data warehousing concept?

662


What is called data cleaning?

618


Is there any rownum object from which we can do this?

522


What is the definition of cube in datawarehousing?

559


Explain the different types of data warehousing?

577