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                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
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 
how can one connect two fact tables ? is it possible ? how?
 Question Submitted By :: Itsranjan
I also faced this Question!!     Rank Answer Posted By  
 
  Re: how can one connect two fact tables ? is it possible ? how?
Answer
# 1		 
This confirm dimenstion methodology.If a dimension table is 
connected to more then one Fact table is called confirm 
dimension.
 
Is This Answer Correct ?    4 Yes 0 No
Thammera
 
  Re: how can one connect two fact tables ? is it possible ? how?
Answer
# 2		 
Fact Tables are connected by confirmed dimensions, Fact 
tables cannot be connected directly, so means of dimension 
we can connect
 
Is This Answer Correct ?    1 Yes 1 No
Raj
 
 
 
  Re: how can one connect two fact tables ? is it possible ? how?
Answer
# 3		 
Two fact tables can connect thru constellation schema. It 
is different from Star and snowflake schemas. In 
constellation schema , we can join to fact tables 
surrounded by dimensions.
 
Is This Answer Correct ?    0 Yes 1 No
Dinesh
 
  Re: how can one connect two fact tables ? is it possible ? how?
Answer
# 4		 
Yes,We can connect two fact tables by using  confirmed
dimension indirectly or directly by confirmed fact.Here when
a fact appears in more than one fact table we can join using
this fact.
eg:
   fact table 1                fact table 2
   ------------                ------------
    measures                     maesures
    revenue    <=======>         revenue
 
Is This Answer Correct ?    1 Yes 2 No
Nethaji
 
  Re: how can one connect two fact tables ? is it possible ? how?
Answer
# 5		 
---------------------------------------------------
      
                       confrimed
          [sales fact]<.........>[customer fact ]
                  |                     |
       dimentions x,y,z          dimentions a,b,c
   -----------------------------------------------------

 when u applied join between  two fact tables u will get a 
confriemd  dimention
 
Is This Answer Correct ?    1 Yes 3 No
Vams_gk
 
  Re: how can one connect two fact tables ? is it possible ? how?
Answer
# 6		 
We can connect two fact tables by using constellation 
schema or galaxy schema.
we have 3 types of schemas

star
snowflake
constellation or galaxy

in star schema we have data redundancy.we do not normalize 
dimension tables.
in snowflake we normalize dimension tables to reduce space
 boyh star aand snowflake we use only one fact and many 
dimesion tables.in some situations we have to use more than 
one fact table then we use constellation.but its vary 
rarely used
 
Is This Answer Correct ?    0 Yes 2 No
Mallika
 

 
 
 
Other Data Warehouse General Interview Questions
 
  Question Asked @ Answers
 
How can you define a transformation? What are different types of transformations in Informatica? TCS3
What is the difference between OLAP, ROLAP, MOLAP and HOLAP?  2
what are different types of partitioning in oracle ?  2
What is Conceptual, Logical and Physical model?  1
what is the difference between etl tool and olap tools  3
What is confirmed dimension?  3
How can Oracle Materialized Views be used to speed up data warehouse queries?  3
5.Explain ODS ? HCL1
When should one use an MD-database (multi-dimensional database) and not a relational one? IBM1
Compare ?Data mining? and ?Data Warehousing??  2
how do you use commit frequencies? how does it affect loading performance?  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
What is difference between Business Objects and Hyperion Essbase? Please help me  1
Hi,Please can u tell me.. What is the difference between a Hyperion Essbase CUBE and a Star Schema? Thanks in advance, Vijay. iFlex1
How many repositories can we create in Informatica? Informatica7
What are cursors?  4
What is DTS ?  1
What is the difference between a W/H and an OLTP application?  4
what is data validation strategies for data mart validation after loading process  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