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

One way of creating a new variable in Macros is by % Let....What is the other way..?

5 Answers   TCS,


what is cummaltive frequency,and varience in proc unviarte

1 Answers   L&T,


Tell e how how dealt with..

0 Answers  


What versions of SAS have you used (on which platforms)?

0 Answers   Quintiles,


What is LAG function?How is it used? can any one explain

3 Answers   TRE, Verinon Technology Solutions,


Name statements that function at both compile and execution time?

1 Answers  


Mention few ways with which a “table lookup’ is done in sas programming.

1 Answers  


i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;

0 Answers   L&T,


what is the difference btw proc means and proc univariate?

8 Answers   HSBC, TCS,


Which function is used to count the number of intervals between two sas dates?

0 Answers  


How can you create a macro variable with in data step? : sas-macro

0 Answers  


What are the main differences between sas versions 8.2, 9.0, 9.1?

4 Answers  


Categories