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

how do u really know that paging to disk is happening while u are using a lookup transform?

0 Answers  

how would u estimate the size of Aggregator transform data and index cache?

0 Answers  

what are the reports developed in sap bw project and what is the requirement for developing it?

0 Answers   Maersk,

1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?

0 Answers  

can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge

0 Answers   Cap Gemini,

how do u decide whether u need to do aggregations at database level or at Informatica level?

1 Answers   QualTech,

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

1 Answers   ABC,

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

4 Answers  

what is HISTOGRAM? how to generate statistics?

1 Answers  

SCD2 will work on only dimension tables as well as fact Table?

0 Answers   Infosys,

working of line item dimension......pls,tell overall flow

1 Answers  

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

1 Answers  

For more ETL Interview Questions Click Here
Categories