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 |
This entry was posted in General. Bookmark the permalink. Post a comment or leave
What is the basic structure of the SAS base program?
In sas, what are the areas that you are most interested in? : sas-grid-administration
i am importing large data from oracle to work library. in log there is a error message worklibrary space is not enough. then how to import the data safely to sas environment.
what is sas data set?
What are MIs reports? what is the use of MIS reports and How can u generate the MIS reports in SAS? If any body know explain with the eg.
2 Answers ABC, ASD Lab, CitiGroup,
How would you invoke a macro? : sas-macro
What is the command used to find missing values?
Mention what is the difference between nodupkey and nodup options?
Best trainer in hyderabad for sas banking.if any one have details pls provide contact details.
What are _numeric_ and _character_ and what do they do?
Mention sas system options to debug sas macros.