what is fact table and factless table?
- 1 Answers
- 6345 Views
- I also Faced
- E-Mail Answers
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 |
Mention the difference between ceil and floor functions in sas?
is data integration and etl programming is same? : Sas-di
who is the best SAS clinical Trainer in Hyderabad?
how do you derive descriptive statistics?
1 Answers Accenture, Quintiles,
DATA ABC; INPUT TDATE DATE9. AVG; CARDS; 18APR2008 150.00 19APR2008 167.00 20APR2008 123.00 21APR2008 145.00 ; RUN HOW CAN I FIND THE DIFFERENCE BETWEEN AVG OF 18APR2008 ANF 21APR2008?? IF ANY ONE GETS IT PLS TRY TO POST IT.
8 Answers Verinon Technology Solutions,
how does sas handle missing values in a merge? : Sas programming
what is factor analysis? : Sas-administrator
what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming
How to specify variables to be processed by the freq procedure?
what are methods to identify duplicate observations?
Tell e how how dealt with..
What is the purpose of using the N=PS option?
Teradata 
