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 LESS FACT TABLE?

Answer Posted / rameshbabu.katikireddy

A fact table ,which does not contain any facts in it.
It can be used,when you does not need any caluculations ,but want to analyse the data for information level.
FACT is business value indicator or measure which are generally in number,
but you can not opposed to affirm or not refuse to acknowledge that there are some fact which are not
being represented in numeric values.
EX: Number of meetings,

for example if we consider one TEST Fact table,that contain s allthese keysare dimensions except one value that is number of meetings. that can be used in information level not in caluculations.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are cluster analysis in data warehousing?

1106


Explain what are the possible data marts in retail sales?

1009


Explain the data type of the surrogate key?

948


What is core dimension?

1059


Tell me what is full load & incremental or refresh load?

950


What is the difference between olap and oltp?

1055


What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

1035


How can you implement many relations in star schema model?

1000


Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?

919


Explain vldb?

1033


What is dimensional modelling?

983


What are the advantages of raid 1, 1/0, and

978


Explain what are necessary tasks to install reportnet software?

923


I know of using applysimple, but there are other ways too?

959


What is data warehouse architecture?

1047