Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between OLTP database and data
warehousing database?
- 3 Answers
- 7084 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
SCD2 will work on only dimension tables as well as fact Table?
What are materialized views & where do we use them?
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?
When do we go for the tools in the market?
Compare etl & elt?
Explain about round-robi?
what is pmrep command?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
what are the data modeling tools you have used?(polaris)
Explain about power designer data modeling software?
how do u extract data from different data sources explain with an example?
What is lookup table in etl testing?
How to increase performance without changing anything in mapping.( In prod)
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
