Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between OLTP database and data
warehousing database?
- 3 Answers
- 7087 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 |
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
What are cubes and olap cubes?
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?
how do u identify the changed records in operational data?
What is a staging area? What is the purpose of a staging area?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
Identifying the bottlenecks in various components of Informatica and resolving them.
what is meant by drill through?(Mascot)
what are the parts of Informatica server ?
What is fact? What are the types of facts?
Do we need an etl tool?
Is apache nifi an etl tool?
Teradata 
