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 
if we increase the number of dimensions will the rows in
fact table increase or decrease??
 Question Submitted By :: Abhishek
I also faced this Question!!     Rank Answer Posted By  
 
  Re: if we increase the number of dimensions will the rows in fact table increase or decrease??
Answer
# 1		 
The number of rows in a fact table depends upon the grain of the fact. Dimensions can only describe the data in the fact table. Adding more dimensions will not increase the number of rows unless it impacts the grain of the fact. e.g You have fact at the granularity of day and u want to now add time intervals dimension.... this will increase the number of rows in fact.
 
Is This Answer Correct ?    12 Yes 1 No
Pratap Gangula
 
  Re: if we increase the number of dimensions will the rows in fact table increase or decrease??
Answer
# 2		 
Yes, if we increase the dimension obviously that key need 
to added in the fact ,

Ex 

1 fact joined 1 dim of 4 key,
I have added 1 dim with 2 keys 

Now my fact will be 8 keys.
 
Is This Answer Correct ?    1 Yes 1 No
Itesh
 
 
 
  Re: if we increase the number of dimensions will the rows in fact table increase or decrease??
Answer
# 3		 
Number of rows wouldn't increase. Number of cloumns will 
increase in fact table as we will have to store the keys of 
those dimensions.
 
Is This Answer Correct ?    1 Yes 0 No
Asha
 

 
 
 
Other Data Warehouse General Interview Questions
 
  Question Asked @ Answers
 
What is the "junk dimension"? Give with examples?  7
When should one use an MD-database (multi-dimensional database) and not a relational one? IBM1
What is difference between Business Objects and Hyperion Essbase? Please help me  1
What is the difference between OLAP, ROLAP, MOLAP and HOLAP?  2
What is data merging, data cleansing and sampling?  1
What is query panel?  1
what is a hot file, why we need in datawarehousing, where we used in general Thomson2
What are cursors?  4
Why do we use DSS database for OLAP tools?  2
How can we do ETL process in SQL Server? ETL1
if we increase the number of dimensions will the rows in fact table increase or decrease?? IBM3
What Oracle tools can be used to design and build a W/H?  1
Tell me one example for multi valued dimension or bridge table? TCS2
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null. IBM1
How does data mining and data warehousing work together?  2
Compare ?Data mining? and ?Data Warehousing??  4
difference between For each and for all  1
what is table partitioning? How it is useful to warehouse database? EDS1
Difference between ODS and Staging TCS3
Which kind of index is preferred in DWH?  1
 
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