Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> ETL
  2. Suggest New Category

what is the difference between OLTP database and data
warehousing database?

Question Posted / jakki

Answers were Sorted based on User's Feedback



what is the difference between OLTP database and data warehousing database?..

Answer / murthy

The main deference between them is

OLTP:used to store current transaction data not large
historical data(ex:bank ATM)
DWH:
used to store historical data aruond 3-6 years.

apart this include the standara differences

Is This Answer Correct ?    6 Yes 0 No

what is the difference between OLTP database and data warehousing database?..

Answer / sanchari chowdhury

Records in a OLTP database can be updated or modified or
deleted. However,the same is not possible in DW.
OLTP database is used for transactional purposes e.g. day-
to-day sales or finance and DW is used for analytical
decisions.DW is mainly used for business decisions to
ensure stability of the organisation by curbing the
possible failures. This is possible because it contains the
historical or the archived data for analysis.

Is This Answer Correct ?    7 Yes 1 No

what is the difference between OLTP database and data warehousing database?..

Answer / parvar

The main difference between oltp and dw are,
Oltp dw
1 current data historical data
2 normalized data de-normalized data
3 small database large database
4 application-oriented subject-oriented
5 row by row loading bulk loading the data
The data

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ETL Interview Questions

What exact we can see in table?

1 Answers  

What are cubes and olap cubes?

0 Answers  

What is tracing level?

0 Answers  

What are the new features of informatica 9 version?

2 Answers  

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

0 Answers   Tech Mahindra,

Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?

0 Answers  

where are the log files generally stored.Can you change the path of the file.what can the path be?

0 Answers  

when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

0 Answers  

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

0 Answers  

1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?

0 Answers  

Need Informatica Power Center 9.1 free download(for all windows version)

1 Answers   ABC,

what is granularity in Data ware House?

0 Answers   IBM,

For more ETL Interview Questions Click Here
Categories