What are Fact tables and Dimension Tables?
- 6 Answers
- 55055 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mallika
A fact table typically has two types of columns: those that
contain facts and those that are foreign keys to dimension
tables. facts may be composed of measures,degenerated
dimensions.The primary key of a fact table is usually a
composite key that is made up of all of its foreign keys
Dimension tables, also known as lookup or reference tables,
contain the relatively static data in the warehouse.
Dimension tables store the information you normally use to
contain queries. Dimension tables are usually textual and
descriptive and you can use them as the row headers of the
result set. Examples are customers or products
| Is This Answer Correct ? | 107 Yes | 16 No |
Answer / nitin
Fact table :- It consists of foreign Keys and MEasures(Numeric values)
Dimension :- It provides descriptive information relating to the foreign key in a fact
Eg:- in employee table i have ename empid sal
in manager table i have mname mid and sal
so there are two dimension table
1--> emp table contains enmae eid(PK) sal
2--> Mgr table contains mname mid(PK) sal
Fact table contains
eid(FK) mid(FK) esal and msal
PLease correct me if i'm wrong
| Is This Answer Correct ? | 30 Yes | 6 No |
Answer / ashok kumar lenak
Dimension Table-The tables through which i can under the
business.
It has wide range of rows.
It is called end dimension table.
It is joined to the Fact table.
Values are textural in nature.
Usually the Master tables are look like the Dimention table.
Fact Table-It is also called the Central table.
Most rows are numeric in nature.
Narrow rows and few columns.
It is accessed by the dimention table.
All the PK of the dimention table is at the fact table.
Usually the transaction tables look like the Fact Table.
| Is This Answer Correct ? | 29 Yes | 13 No |
Answer / vensh
Dimension table is nothing but a table which contains detailed description about the data except any values...
Fact table mainly contains the facts nothing but the values that is related to the data in the dimension table and by using the primary key in dimension table and the foreign key in the fact table we will map the dimensional table and the fact table
| Is This Answer Correct ? | 13 Yes | 2 No |
Answer / gattu srinivasarao
FactTable:It consists of th efacts and references of the diminision tables.
Diminsion table:It consists only charchter values,for example cus_name,cus_add,etc..
| Is This Answer Correct ? | 6 Yes | 4 No |
Answer / 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 |
Explain what is fact less fact table? Where you have used it in your project?
Could any one explain me how to create cascading prompts?
How many repositories can we create in Informatica?
Explain meta data?
What are data modeling and data mining? Where it will be used?
What is an error log table in informatica occurs and how to maintain it in mapping?
How to pivot data using informatica when you have variable amount of pivot rows?
What are session timeout and application timeout? Where we have to do this process?
What is the use of tabular model, tabular sql, tabular reference in real time application?
What is data cleaning? How can we do that?
Difference between e-r modeling and dimentional modeling?
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?
Teradata 
