GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing

 Print  |  
Question:  what are the types of dimension tables



May 05, 2006 01:19:32 #8
 Ashish Sharma   Member Since: Visitor    Total Comments: N/A 

RE: what are the types of dimension tables
 

What is this? No one know waht are the diffrent types of dimesnsions? Who's answer is correct, everyone is giving there own answers.

Actually the question is wrong and is not mentioned in which case it is talking about.

I think there are following types of dimensions:

1. SCD or slowly changing dimension.

2. SGD or slowly Growing Dimension. ( Type 1, Type 2 and Type 3)

There are other three types of Dimensions:

1. Confirmed Dimensions.

2. Junk Dimensions.

3.  Degenerative Dimensions.

Regards,

Ashish Sharma

     

 

Back To Question