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

In document how to create metrics?

933


What are the various tools? Explain name a few?

898


What is the working process for application.cfm?

980


Explain bus schema?

894


Explain which are the olap tools available that are supported by oracle?

940


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

916


How can we run the graph? How can we schedule the graph in unix?

881


why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.

1904


Explain what are the advantages and disadvantages of reporting directly against the database?

951


Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?

949


Explain what is ods (operation data source)?

926


How can we schedule the graph in unix?

931


Why should we use data ware housing and how can you extract data for analysis with example?

934


Explain what is cost benefit analysis (cba)?

924


Why facts table is useful in representing the data?

929