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       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
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
where exactly in dataware house a confirmed dimension can 
be created
 Question Submitted By :: Raj
I also faced this Question!!     Rank Answer Posted By  
 
  Re: where exactly in dataware house a confirmed dimension can be created
Answer
# 1
A confirmed Dimension, by definition, means a single
dimension table is actually connected to more than one fact
table in your dimensional model.
So, if a dimension table is shared across two fact tables,
for example, then that dimension is called as Conformed
Dimension.

PS: It is NOT Confirmed Dimension but it is Conformed Dimension.
 
Is This Answer Correct ?    8 Yes 5 No
Sandeep.pamarati
 
  Re: where exactly in dataware house a confirmed dimension can be created
Answer
# 2
This dimensions are something that is built once in your model and can be reused multiple times with different fact tables.  For example consider a model containing multiple fact tables representing different data marts. Now look for a dimension that is common to these facts tables. In this example let’s consider that the product dimension is common and hence can be reused by creating short cuts and joining the different fact tables.Some of the examples are time dimension customer dimensions product dimension.
 
Is This Answer Correct ?    0 Yes 0 No
Prodyot Sarkar
 
 
 

 
 
 
Other Data Warehouse General Interview Questions
 
  Question Asked @ Answers
 
5.Explain ODS ? HCL3
how can one connect two fact tables ? is it possible ? how? ABC7
1.WHAT IS DATA MART ? HCL4
three ways sql*loader could load data, what are those three types?  1
difference between For each and for all  1
Advantages of de normalized data?  2
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 table partitioning? How it is useful to warehouse database? EDS1
What is BCP?  1
How to use the tool Ontobulider  1
What is ?Data Warehousing??  2
What is Drill by? drill through? iFlex1
capital of tamilnadu Wipro1
why oracle is the best database for data warehousing? HCL2
How can Oracle Materialized Views be used to speed up data warehouse queries?  3
How can we import and export using BCP utility?  1
What is the capacity of power cube?  1
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
what is query optimizer? what are different types of optimizer s supported by oracle ? ABC1
What is a Data Cube?  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