Answer Detail: RE: what are the types of dimension tables

GeekInterview.com > Interview Questions > Data Warehousing

Print |

Question: what are the types of dimension tables

December 12, 2005 08:41:54	#4
Siva K	Member Since: Visitor Total Comments: N/A
RE: what are the types of dimension tables
There are three types of Dimesions Confirmed Dimensios, Junk Dimesions, Degenerative Dimesions Comfirmed is some thing which can be shared by shared by multiple Fact Tables or multiple Data Marts. Junk Dimensiions is grouping flagged values Degenerative Dimension is something dimensional in nature but exist fact table.