what is the difference between OLTP database and data
warehousing database?
- 3 Answers
- 5871 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 |
What are cubes and olap cubes?
How we can see table structure?
What are materialized views & where do we use them?
What are the modules in Power Mart?
When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.
Identifying the bottlenecks in various components of Informatica and resolving them.
what is session partitioning?
What is fact? What are the types of facts?
when will use SQL override in a lookup transformation?
What do you understand by the term ‘transformation’?
what types of repositories we can create in informatica? in real time in which type of repository we will work on?
Do we need an etl tool?
Teradata 
