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 |
The below code we are using for creating more than one macro variables in proc sql using into clause. How we can use same code to create macro variables vara, varb, varc instead of var1, var2, var3.? proc sql noprint; select count(distinct(patient)) into :var1 - :var3 from dataset1 group by trtreg1c ; quit;
what is sas database server? : Sas-di
how do you read binary data in sas?
Why Info School? BUILD YOUR CAREER WITH RIGHT GUIDANCE AND SUPPORT SAS Training in Data Management at InfoSchool Bangalore
Give some examples where proc report’s defaults are different than proc print’s defaults?
Why is SAS considered self-documenting?
What can you learn from the SAS log when debugging?
How you can read the variables that you need?
Difference between nodup and nodupkey options?
what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming
What is the use of %include statement?
name several ways to achieve efficiency in your program? : Sas programming