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 
DWH architecture?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: DWH architecture?
Answer
# 1		 
it is composed of dataware house 
layer,datastagelayer,process management layer,meta data 
layer,application layer and other etc
 
Is This Answer Correct ?    0 Yes 0 No
Ajay Kumar
 
  Re: DWH architecture?
Answer
# 2		 
THE ARCHITECTURE CONTAINS THE FOLLOWING COMPONENTS
           1.OLTP SYSTEMS
           2.STAGING LAYER
           3 DATA WAREHOUSE
           4.DATA MARTS
           5.REPORTS
           6.BUSINESS USERS
 
Is This Answer Correct ?    0 Yes 0 No
Sandeep.t Nizamabad
 
 
 
  Re: DWH architecture?
Answer
# 3		 
OLTP SYSTEMES CONTAINS
        1.FLAT FILES
        2.DBASE
        3.ORACLE
        4.SAP
WE WILL EXTRACT THE DATA FROM OLTP TO STAGING LAYER
AND CONVERT THE DATA FROM INCONSISTENT TO CONSISTENT FORM 
BEFORE LOADING TO DWH.
DWH IS NOTHING BUT OLAP SYSTEMS
IT CONTAINS DEPTS. LIKE FINANCE,SALES,PURCHASE,H.R
DATA MARTS ARE SUBSETS OF AWHWHICH ARE USED TO SATISFY THE 
REPORTING REQUIREMENTS OF A DEPTS
Eg:  SALES , FINANCE,PURCHASE,HR
 
Is This Answer Correct ?    0 Yes 0 No
Sandeep.t Nizamabad
 

 
 
 
Other Data Warehouse General Interview Questions
 
  Question Asked @ Answers
 
Give me a broad concept of what a data warehouse is, and what it might be used for?  2
What is the difference between a W/H and an OLTP application?  4
What is BCP?  1
What is DTS ?  1
What is the difference between Oracle Express and Oracle Discoverer?  1
What is an OLAP (On-line Analytical processing) system?  1
What is mapplet?  1
Hierarchy of DWH? Accenture1
What is source qualifier?  1
What is MDX? TCS1
What is Molap and Rolap? What is Diff between Them?  2
what is the use of surrogate key in businessobjects  1
How can we import and export using BCP utility?  1
How can you define a transformation? What are different types of transformations in Informatica? TCS3
What is difference between a connected look up and unconnected look up?  1
what are different types of partitioning in oracle ?  2
What is Drill by? drill through? iFlex1
What is confirmed dimension?  3
Advantages of de normalized data?  1
How to use the tool Ontobulider  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