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?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?

2095


name some data transformation used in sas di? : Sas-di

954


What do the SAS log messages "numeric values have been converted to character" mean?

1364


is data integration and etl programming is same? : Sas-di

1056


What are the scrubbing procedures in sas?

991


Differentiate between ceil and floor functions.

1142


What is the general format of function in sas? : sas-grid-administration

953


what other sas products have you used and consider yourself proficient in using? : Sas programming

1096


How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

1080


explain the proc in sas? : Sas-administrator

1076


How to convert a numeric variable to a character variable?

1179


if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation

1604


How can you limit the variables written to output dataset in data step?

1305


In ARRAY processing, what does the DIM function do?

1152


Describe a time when you were really stuck on a problem and how you solved it?

2531