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
Next Question 
 Data Warehousing  |  Question 1 of 86    Print  
what are the types of dimension tables

  
Total Answers and Comments: 20 Last Update: March 12, 2008     Asked by: narasimha 
  
 Sponsored Links



 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
  Sorting Options  
  Page 1 of 2   « First    1    2    >     Last »  
November 09, 2005 06:38:47   #1  
bawa        

RE: what are the types of dimension tables

Dimensions are of 3 types mainly in case of slowly changing dimensions:

Type 1 ->Doesnt maintain any history and is update only.

Type 2-> Maintains full history.Insert row when certain attributes change else update row.The latest record is identified by a flag or date field which is called the MRI or Most Recent Indicator

Type 3->Maintains partial history.History is maintained as columns and not rows.Hence it is predecided as to till how many levels of history you want to maintain.


 
Is this answer useful? Yes | No
November 14, 2005 05:16:23   #2  
prathiba        

RE: what are the types of dimension tables

 infromational dimension

strutral dimension

conformed dimesion


 
Is this answer useful? Yes | No
November 15, 2005 18:49:32   #3  
bs        

RE: what are the types of dimension tables
Flat dimensions and snow flake.
 
Is this answer useful? Yes | No
December 14, 2005 08:41:54   #4  
Siva K        

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.


 
Is this answer useful? Yes | No
January 04, 2006 05:29:34   #5  
sithusithu Member Since: December 2005   Contribution: 161    

RE: what are the types of dimension tables

Hi prathiba,

can you tell me how the dimenions are seperated?

Sithu

sithusithu@hotmail.com


 
Is this answer useful? Yes | No
February 14, 2006 01:37:07   #6  
piyush        

RE: what are the types of dimension tables

there are five types of dimensions:

1. star schema

2. snowflake schema

3.parent-child schema

4.virtual dimension

5. mining model


 
Is this answer useful? Yes | No
April 17, 2006 06:26:59   #7  
amit        

RE: what are the types of dimension tables

Hi,

 Can u detail ab't 3 dimensions.

regards

Amit


 
Is this answer useful? Yes | No
May 08, 2006 01:19:32   #8  
Ashish Sharma        

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


 
Is this answer useful? Yes | No
June 06, 2006 00:12:34   #9  
keerthi        

RE: what are the types of dimension tables

can you explain in detail the following with examples:

1. junkdimension

2.conformed dimension

3degenarative dimension.


 
Is this answer useful? Yes | No
August 12, 2006 02:51:29   #10  
saba        

how to test the reports
how to test the reports and how do we appy ad hoc queries while execution
 
Is this answer useful? Yes | No
  Page 1 of 2   « First    1    2    >     Last »  


 
Go To Top


 Sponsored Links



 
Sponsored Links

 
Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape