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

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

3 Answers   Accenture, Oracle,


What is the Program Data Vector (PDV) and What are its functions?

9 Answers  


Explain what is SAS informats?

0 Answers  


What are the statements that are executed only?

0 Answers  


What is Transaction...? And what are Comment, Roll back n Save point..?

2 Answers  


which date function advances a date, time or datetime value by a given interval? : Sas programming

0 Answers  


what are the advantages of using SAS in clinical data mangement? why should not we use other software products in managing clinical data?

2 Answers   Wockhardt,


what is difference in window SAS & Unix SAS.....how do define working environment in both???

1 Answers   JPMorgan Chase,


what are 5 ways to perform a table lookup in sas? : Sas-administrator

0 Answers  


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.

1 Answers   TCS,


What is the SAS data set?

0 Answers  


What does the trace option do?

0 Answers  


Categories