Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between OLTP database and data
warehousing database?
- 3 Answers
- 7276 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
when will use SQL override in a lookup transformation?
what are the types in error loging?
What are dimensions?
what is pmrep command?
Explain the difference between etl tool and olap tools?
how would u estimate the size of Aggregator transform data and index cache?
Do we need an ETL tool? When do we go for the tools in the market?
dimension object created in oracle can be imported in designer?how?
what is the main role of FI on business
State the differences between shortcut and reusable transformation
list and discuss two approaches for updation of target table in Informatica and how they are different.
Define slowly changing dimensions (SCD)?
what is the use of server?
How to increase performance without changing anything in mapping.( In prod)
What is etl tool in hadoop?
