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

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1 Answers  

what is the difference steps for data modeling?

0 Answers  

list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys

2 Answers  

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

0 Answers  

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

0 Answers  

Can u access a repository created in previous version of Informatica?

0 Answers  

When do we analyze the tables?

0 Answers  

we hava more than 1000 records. i have to select first 5 record, last 5 record and 5 records from middle of the source. how can i do in oracle as well as in informetica??

4 Answers  

What is etl process? How many steps etl contains?

0 Answers  

when should one create lookup transformation ?

2 Answers  

Explain me ETL project architecture in Detail?

0 Answers   Infosys,

my name is amar i want display 1st line A 2nd line M 3rd line A 4th line R in database & informatica

1 Answers   HCL,

For more ETL Interview Questions Click Here
Categories