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

What is the difference between ods and oltp?

565


What is difference macros and prompts?

1711


Explain the data types present in bo n wht happens if we implement view in the designer n report?

536


How many project sources we can create in metadata?

557


What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?

529






What is a linked cube?

535


Explain difference between view and materialized view?

505


what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc

2049


What is fact less fact table? Where you have used it in your project?

507


Whether dimension table can have numeric value?

598


What is hybrid slowly changing dimension?

620


How to pivot data using informatica when you have variable amount of pivot rows?

517


How to define a cube??

546


How to design file watch jobs?

576


Explain a mapping, session, worklet, workflow, mapplet?

592