what is the difference between OLTP database and data
warehousing database?
- 3 Answers
- 5868 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?
how do u implement unconn.stored proc. in a mapping?
Mention few test cases and explain them?
how would u estimate the size of Aggregator transform data and index cache?
What is lookup table in etl testing?
what is the use of structures?how many nodes can u create in a structure?
What are materialized views & where do we use them?
What is meant by incremental load?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
What is granularity? Please explain with example
How many types of transformations supported by sorted input?
Teradata 
