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 a fact table?

Answer Posted / dipti a

Fact Table is the central table which has factual information. It contains numeric information and measures.
Lets say if you need to capture sales data then centrally we can have sales table(fact table) which contains numeric information and surrounding to it, we can have dimensions table like product dimensions, date dimensions, store dimensions.
So this central fact table will contacts numeric information like Prize_of_product, Qualntity and along with same we can have dimension foreign keys like product_id, store_id, date_id and so on.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the data types present in bo?

1046


Explain a mapping, session, worklet, workflow, mapplet?

1037


What is surrogate key? Where we use it?

935


Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?

921


What is the difference between aggregate table and materialized view?

1031


How can we acheive correlated sub-query in designer?can anyone help me in this regard?

894


How to export mappings to the production environment?

836


What are the various methods of getting incremental records or delta records from the source systems?

888


Suppose we want to display zero when null values coming to report how can we do that?

865


What is data analytics in simple terms?

1084


How to reduce warnings?

902


What is the advantages data mining over traditional approaches?

909


Explain what are the advantages of query studio compared to report studio?

968


What is called data cleaning?

1143


Difference between PowerPlay transformer and power play reports?

2479