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 
what is a hot file, why we need in datawarehousing, where 
we used in general
 Question Submitted By :: Ramesh
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is a hot file, why we need in datawarehousing, where we used in general
Answer
# 1		 
Hot File:If we generate a report from two different 
database, at that time we go for Hot File.The only drawback 
is it will occupy the whole space in the hard disk.

Need of DWH:if u want enterprise reporting and analysis 
from your historical data.
 
Is This Answer Correct ?    1 Yes 1 No
Shree Uday
 

 
 
 
Other Data Warehouse General Interview Questions
 
  Question Asked @ Answers
 
DWH architecture?  3
What is operational data source (ODS)?  1
What is difference between a connected look up and unconnected look up?  1
5.Explain ODS ? HCL1
1.WHAT IS DATA MART ? HCL1
What is a star schema? Why does one design this way?  2
what is query optimizer? what are different types of optimizer s supported by oracle ?  1
Give me a broad concept of what a data warehouse is, and what it might be used for?  2
When should you use a STAR and when a SNOW-FLAKE schema? Accenture5
how do you use commit frequencies? how does it affect loading performance?  1
What is aggregate awareness?  2
What is staging area?  6
how can one connect two fact tables ? is it possible ? how? ABC6
Where can one get more info about Data Warehousing? TCS2
difference between bo 6.5 and bo xi r2 Accenture1
What is factless fact schema?  1
Explain about Control M JObs detaily?How to execute this. Scope-International2
What is the difference between an ODS and a W/H?  1
How many repositories can we create in Informatica? Informatica7
what are the types of dimension tables  6
 
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