ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Data Warehouse General
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question 
what are the types of dimension tables
 Question Submitted By :: G Ruban
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what are the types of dimension tables
Answer
# 1		 
1. Dimension
2. Detail
3. Measure
 
Is This Answer Correct ?    2 Yes 8 No
Guest
 
  Re: what are the types of dimension tables
Answer
# 2		 
1.Confirmed Dimension.
2.Junk Dimension.
3.Degenerated Dimension.
4.Slowly changing Dimensions.
 
Is This Answer Correct ?    9 Yes 2 No
Chol Thakur
 
 
 
  Re: what are the types of dimension tables
Answer
# 3		 
There are many dimension tables.
The commonly used are 
Confirmed dimension,
Junk dimension,
Degenerated dimension,
Slowly changing dimension,
Rapidly changing dimension

The others are 
Virtual dimension,
Regular dimension,
Casual dimension,
Shared dimension,
monster dimension.
These  are used on certain condtions.
 
Is This Answer Correct ?    2 Yes 5 No
Nethaji
 
  Re: what are the types of dimension tables
Answer
# 4		 
Rapidly changing dimensions,
confirmed dimensions,
slowly changing dimensions and
slowly growing targets
 
Is This Answer Correct ?    5 Yes 2 No
Annu
 
  Re: what are the types of dimension tables
Answer
# 5		 
1.star schema

2.snowflake schema

3.glaxy schema
 
Is This Answer Correct ?    2 Yes 8 No
Anitha
 
  Re: what are the types of dimension tables
Answer
# 6		 
TABULAR DIMENSION                                          
 STAGEREG DIMENSION                                        
  BASELINE DIMENSION                                       
   COORDINATES                                             
    GROUP DIMENSION                                        
     CONTOUR DIMENSION                                     
       CENTER LINE
 
Is This Answer Correct ?    3 Yes 2 No
Carlos Siao
 

 
 
 
Other Data Warehouse General Interview Questions
 
  Question Asked @ Answers
 
What are Data Marts?  2
What is difference between Business Objects and Hyperion Essbase? Please help me  1
What is Molap and Rolap? What is Diff between Them?  2
What is a star schema? Why does one design this way?  2
What is Conceptual, Logical and Physical model?  1
Which kind of index is preferred in DWH?  1
What is XMLA ?  1
Can you explain how analysis service works?  1
what is the difference between etl tool and olap tools  3
How can we import and export using BCP utility?  1
wat is code review and wat actually srs or how can we create HLD,LLD.PLS,GIVE ME ANSWER AS EARLY AS FAST.  1
Where can one get more info about Data Warehousing? TCS2
wht is degenerated dimension ?it's uses? CTS8
How can you define a transformation? What are different types of transformations in Informatica? TCS3
Compare ?Data mining? and ?Data Warehousing??  2
What is an OLAP (On-line Analytical processing) system?  1
what is indexing ? what are different types of indexes supported by oracle ?  2
explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF ORACLE 8I IBM1
three ways sql*loader could load data, what are those three types?  1
What is Bulk Insert?  3
 
For more Data Warehouse General Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com