Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between OLTP database and data
warehousing database?
- 3 Answers
- 7282 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
how do u identify the changed records in operational data?
What are the different Lookup methods used in Informatica?
What is a mapping, session, worklet, workflow, mapplet?
Explain the difference between etl tool and olap tools?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Identifying the bottlenecks in various components of Informatica and resolving them.
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
What do you understand by active and passive transformations?
What is the difference between Data Warehousing and Data Mining?
what is Forward,Reverse and Re_engineering?
what is the difference between cubes and package in cognos
What are your responsibilities as an etl tester?
what is a worklet?
where we cannot use sorter Transformation. if we use then we will not get correct data?
What are dimensions?
