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 are Fact tables and Dimension Tables?

Answer Posted / ansari

Fact table: It contains numeric values and also contain
composite key(i.e collection of foreign key) e.g.. sales
and profit.
Dimension table: It contains character values E.g
Customer_name,Customer_city.

Is This Answer Correct ?    48 Yes 79 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain a relation schema and a relation?

1111


What are session timeout and application timeout? Where we have to do this process?

1045


What is the difference between a primary and secondary actor in use case modeling?

1066


How do you setup Lo-cockpit?

3166


Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?

963


What is is the guidelines to build universe with better performance? R performance tuning issues of universes?

898


What are templates in which way it is help full?

996


Explain what is the extension of file to save template?

977


How can we determine what records to extract?

1083


Explain what is the difference between view filter and report filter?

980


What is execution plan?

1206


What is a core dimension?

1070


Why facts table is useful in representing the data?

1005


explain about balanced dimension,

983


Can decision tree be implemented using SQL?

2128