what is fact table and factless table?



what is fact table and factless table?..

Answer / kishorebabu

Fact Table
The centralized table in a star schema is called as FACT
table. A fact table typically has two types of columns:
those that contain facts and those that are foreign keys to
dimension tables. The primary key of a fact table is
usually a composite key that is made up of all of its
foreign keys.



In the real world, it is possible to have a fact table that
contains no measures or facts. These tables are called as
Factless Fact tables.


Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SAS Interview Questions

how to import XTP files into SAS datasets?

1 Answers   Barclays, Institute For Plasma Research,


What is the difference between Proc tabulate and Proc print

4 Answers   CitiGroup,


What is difference between Global n Local Macro Variables..?

6 Answers   TCS,


what type of graphs we will create(for 2+years candidates)?

0 Answers   Accenture, Icon,


How would you include common or reuse to be processed along with your statements?

0 Answers  






What does a PROC TRANSPOSE do?

8 Answers   Accenture,


AE datasets names? how many types?

0 Answers   Accenture,


What is the use of PROC gplot?

0 Answers  


What are some problems you might encounter in processing missing values? In Data steps? Arithmetic? Comparisons? Functions? Classifying data?

1 Answers   Quintiles,


if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...

0 Answers   Accenture,


Differentiate between proc means and proc summary.

0 Answers  


what are the advantages of using SAS in clinical data mangement? why should not we use other software products in managing clinical data?

2 Answers   Wockhardt,


Categories