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

Hi, Lookup() is what kind of join ?

6 Answers   Satyam,

what is the difference between shortcut of an object and copy of an object? compare them?

1 Answers  

what is session partitioning?

0 Answers  

how many steps are there in etl process?

0 Answers  

what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?

0 Answers   Accenture,

what is session partitioning?

1 Answers  

Explain what are the various etl tools in the market?

0 Answers  

Define slowly changing dimensions (SCD)?

0 Answers  

What are the three tiers in etl?

0 Answers  

How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

0 Answers   IBM, Saama Tech, Wipro,

What is factless fact schema?

3 Answers  

I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way

2 Answers  

For more ETL Interview Questions Click Here
Categories