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

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

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.

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

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..

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.

If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?

3 Answers   Extech, Principal Finance,

In document how to create metrics?

0 Answers  

What is data mart in data warehouse?

0 Answers  

How to add a number to a macro variable?

0 Answers  

Select * from emp,dept,loc where emp.deptno left outer join dept.deptno and dept.locno=loc.locno. No need to consider the syntax but is it possible to have left outer join and equi join in the same SQL like this ? can we have right outer join and left outer join in the same SQL ---

1 Answers   Principal Finance, PT Metalogix Infolink Persada,

which automation tool is used in data warehouse testing?

1 Answers  

What is the difference between OLAP, ROLAP, MOLAP and HOLAP?

2 Answers  

Can we start and stop single session in concurent bstch?

0 Answers  

What is data stream and data adaopter. Is it same are different? Explain?

0 Answers  

Compare and contrast aggregates & indexes

0 Answers   IBM, TCS,

What are the different types of Fatcs? Explain with example only

3 Answers   CTS,

What is the difference between ods and oltp?

0 Answers