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                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   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 I have table T1 and table T2

T1 has 250 cols and 10,000 rows
T2 has 2 billion rows and 10 cols

Which one would be Fact table and which one would be 
Dimension table and why ?
 Question Submitted By :: Achoudhr
I also faced this Question!!     Rank Answer Posted By  
 
  Re: If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?
Answer
# 1		 
Whether table T1 and T2 are dimension or fact table depends
on the information they store. If the all the measures are
in T1 with dimensions key in it then T1 table is fact and if
T1 is having a pk and textual information then it is
dimension and visa versa.

Idealy the number of row in fact table is very high. In this
case it looks like T2 may be the fact and T1 may be the
dimension. But cann't be said for sure as the information
given is incomplete.
 
Is This Answer Correct ?    8 Yes 1 No
Bluegems
 
  Re: If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?
Answer
# 2		 
A table being set as a Fact or Dimension depends on the 
kind of data it stores.Measures and keys are stored in 
Facts and Dimension stores a primary key and other 
information depending up on the dimension.
 
Is This Answer Correct ?    2 Yes 0 No
Nithin
 
 
 
  Re: If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?
Answer
# 3		 
Dimensions are wide - facts are deep.
T1 will be dimension table (example "customer" with all the 
related attributes like address, tel etc)
T2 will be your fact table (example "orders") which uses 
one column as surrogate key to link to T1 ("customers" in 
this case)
 
Is This Answer Correct ?    2 Yes 0 No
Henry
 

 
 
 
Other Data Warehouse General Interview Questions
 
  Question Asked @ Answers
 
How to use the tool Ontobulider  1
What Oracle features can be used to optimize my Warehouse system?  1
Compare ?Data mining? and ?Data Warehousing??  4
What is confirmed dimension?  5
capital of tamilnadu Wipro1
what is a hot file, why we need in datawarehousing, where we used in general Thomson2
What are cursors?  4
What is staging area?  7
in siebel analytics by using dashboard prompts in a page have 2 reports so i have to give dashboard prompt to applied on first report only that will not applied to 2 report how it will do IBM1
What is an OLAP (On-line Analytical processing) system?  1
What is Molap and Rolap? What is Diff between Them?  9
What is operational data source (ODS)?  2
why oracle is the best database for data warehousing? HCL2
What is Drill by? drill through? iFlex1
what is query optimizer? what are different types of optimizer s supported by oracle ? ABC1
What is ?Data mining??  2
What is the difference between OLAP, ROLAP, MOLAP and HOLAP?  2
How Materialized Views are linked with Oracle DataWare house? Kirloskar1
What is a look up function? What is default transformation for the look up function?  1
What is source qualifier?  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