deepak
Answered On : Jun 5th, 2005
A fact table in dataware house is it describes the transaction data.It contains characterstics and keyfigures.
2 Users have rated as useful.
Login to rate this answer.
etl-new
Answered On : Jun 24th, 2005
A Fact table is a collection of facts and foriegn key relations to the dimensions.
2 Users have rated as useful.
Login to rate this answer.
Meenal
Answered On : Jul 14th, 2005
Fact Table contains the measurements or metrics or facts of business process. If your business process is "Sales" , then a measurement of this business process such as "monthly sales number" is captured in the Fact table. Fact table also contains the foriegn keys for the dimension tables.
4 Users have rated as useful.
Login to rate this answer.
Fact table contains the transactions data ,which have more columns and less no of rows.
Among the data it also includes the foreign key of the dimension tables which r attached to it.
Login to rate this answer.
tapas
Answered On : Jan 24th, 2006
Fact Table contains the keys(primary key,foreign key) of the releated dimension tables and measures which is based on the keys.
Login to rate this answer.
sangroover
Answered On : Feb 15th, 2006
Fact table will have numeric coloums.
Or Values of the coloumns in Dimension table
Login to rate this answer.
Kiran Cholleti
Answered On : Apr 17th, 2006
fact table which represents the information of measurments and aswell as the foreign key of dimention table.... if am wrong please inform me
kiran cholleti
Login to rate this answer.
Its a table which contains only measures like total,distance,Fare,Number of parcels,Weight etc.
It contains only numeric values and contains foreign keys.
Login to rate this answer.
chandrarekha
Answered On : May 7th, 2007
A Fact table contains a composite key where each candidate key is the foreign key of the dimension table
Login to rate this answer.
sridhar
Answered On : May 30th, 2007
Fact table is the one which contains measures of interest at most granular level.These values are numeric.Ex:sales amount would be a measure .
Each dimension table has a single-part primary which exactly corresponds to one of the components of multiparty key in fact table.
The Dimension table provides detailed info about the facts.eg:quarter,year corresponding to sales amount would be part of dimension table.
2 Users have rated as useful.
Login to rate this answer.
A fact table in a data warehouse is one which contains the numeric data, can be further distributed as 'Additive Facts' and 'Non-Additive Facts'.
Additive facts can be the sum of salaries.
Non-Additive facts can be something containing the averages.
most importantly it contains a multiple-part key, composed of the primary keys of the dimension table.
Login to rate this answer.
Fact table is a normalized table divided in to 2 parts
- Link to all dimension tables -> First part of fact table contains set of foreign keys which links to the respective dimension tables.
- Evaluated facts from linked tables -> Second part of fact table contains the summerised set of aggrigated values which helps management in decision making process.
Login to rate this answer.
A fact table is an entity representing the numerical measurements or metrics or facts of the business Eg: Billings table,Bookings table,Accounts table
A dimension table is the entity describing the textual representation of the business.
Eg: Customer table,Customer Address Table,Product table,Time dimension table
In a banking model the account and balances are the measurements with in the fact table where as customer name,social security address, time period of the account are the dimensions (customer/time).
Hope it clarifies
Munavar Shaik
Login to rate this answer.
