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 |
Name statements that are recognized at compile time only?
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
what is broad cast agent? : Sas-bi
what is the effect of the options statement errors=1? : Sas programming
How would you define the end of a macro? : sas-macro
What will calendar procedure do?
what is the difference between x=substr(name,1,2); and substr(name,1,2)='x';
Mention what are the data types does SAS contain?
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
How many data types are there in SAS?
Have you ever linked SAS code, If so, describe the link and any required statements used to either process the code or the step itself?
what is the difference between DUPKEY and NODUPKEY???