Answer Detail: RE: Is a fact table normalized or de-normalized?

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Print |

Question: Is a fact table normalized or de-normalized?

July 07, 2006 17:01:49	#2
Srinivas Chaitanya Reddy	Member Since: Visitor Total Comments: N/A
RE: Is a fact table normalized or de-normalized?
Well!! A fact table is always DENORMALISED table. It consists of data from dimension table (Primary Key's) and Fact table has Foreign keys and measures. Thanks!!