Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


what is fact table and factless table?



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

Post New Answer

More SAS Interview Questions

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;

1 Answers   Accenture,


what is sas database server? : Sas-di

0 Answers  


how do you read binary data in sas?

3 Answers   Satyam,


Why Info School? BUILD YOUR CAREER WITH RIGHT GUIDANCE AND SUPPORT SAS Training in Data Management at InfoSchool Bangalore

1 Answers  


Give some examples where proc report’s defaults are different than proc print’s defaults?

0 Answers  


Why is SAS considered self-documenting?

1 Answers   Quintiles,


What can you learn from the SAS log when debugging?

0 Answers   Quintiles,


How you can read the variables that you need?

0 Answers  


Difference between nodup and nodupkey options?

0 Answers  


what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming

0 Answers  


What is the use of %include statement?

0 Answers  


name several ways to achieve efficiency in your program? : Sas programming

0 Answers  


Categories