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 |
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
What is difference between Global n Local Macro Variables..?
what type of graphs we will create(for 2+years candidates)?
How would you include common or reuse to be processed along with your statements?
What does a PROC TRANSPOSE do?
AE datasets names? how many types?
What is the use of PROC gplot?
What are some problems you might encounter in processing missing values? In Data steps? Arithmetic? Comparisons? Functions? Classifying data?
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 ...
Differentiate between proc means and proc summary.
what are the advantages of using SAS in clinical data mangement? why should not we use other software products in managing clinical data?