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 will you assign all the variables of an dataset into a macro variable separated by a space? For example if a dataset has variables A,B,C. Assign them to a macro variable X as X=A B C
What is the Program Data Vector (PDV) and What are its functions?
Explain what is SAS informats?
What are the statements that are executed only?
What is Transaction...? And what are Comment, Roll back n Save point..?
which date function advances a date, time or datetime value by a given interval? : Sas programming
what are the advantages of using SAS in clinical data mangement? why should not we use other software products in managing clinical data?
what is difference in window SAS & Unix SAS.....how do define working environment in both???
what are 5 ways to perform a table lookup in sas? : Sas-administrator
how does sas know on which server the piece of code to be executed ? say if a proc olap code is written then how the sas application would detect on which server to execute.
What is the SAS data set?
What does the trace option do?