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   To Refer this Site to Your Friends   Click 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 
What is an OLTP (Online Transaction Processing) System?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is an OLTP (Online Transaction Processing) System?
Answer
# 1		 
It stands for OnLine Transaction Processing.It is used to 
record transaction.Day to Day transactions are recorded. 
Data is highly Volatile.Highly Normalized.Used to generate 
Information Reports.
 
Is This Answer Correct ?    1 Yes 0 No
Azhar
 
  Re: What is an OLTP (Online Transaction Processing) System?
Answer
# 2		 
1.oltp stands for online transaction process
2.transactions will be done in this process
3.this should be use by clerical users
4.IT CONTAINS ONLY CURRENT DATA
5.WE CAN STORE THE DATA UPTO ONE YEAR
6.THE DATA TYPE IS VOLATILE
7.IT CONTAINS THE DETAILED DATA
8.ROUTINE ACTIVITIES ARE IMPLEMENTED
9.ONE RECORD ONLY PROCESSED AT A TIME
10.INSERT,UPDATE,DELETE OPERATIONS ARE USED
 
Is This Answer Correct ?    1 Yes 0 No
Sandeep.t Nizamabad
 
 
 

 
 
 
Other Data Warehouse General Interview Questions
 
  Question Asked @ Answers
 
How many repositories can we create in Informatica? Informatica7
What is surrogate key? IBM4
What is ?Data Warehousing??  2
3.What is fact less fact ? HCL2
What is query panel?  1
2.What is staging area ? HCL1
When should one use an MD-database (multi-dimensional database) and not a relational one? IBM1
What is ?Data mining??  2
What is Conceptual, Logical and Physical model?  1
how can one connect two fact tables ? is it possible ? how? ABC6
1.WHAT IS DATA MART ? HCL1
What is aggregate awareness?  2
What is a star schema? Why does one design this way?  2
What is Snow Flake Schema design in database?  2
What is Data purging? TCS4
Tell me one example for multi valued dimension or bridge table? TCS1
How can Oracle Materialized Views be used to speed up data warehouse queries?  3
What is subject area?  2
What is a Data Cube?  1
Which kind of index is preferred in DWH?  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