Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between OLTP database and data
warehousing database?
- 4 Answers
- 7465 Views
- I also Faced
- E-Mail Answers
Answer Posted / ankit kansal
OLTP systems are designed to handle events (Inserts,Update,Delete) frequently so its better to keep your database more normalized form as selection is not as frequent where as in case of
OLAP systems are designed purely for analysis or to find out trends using historical data so, to achieve this kind of functionality a data warehouse are designed more de-normalized where query(selection) is much faster.
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
where is the cache (lookup, index) created and how can you see it.
what is the meaning of upgradation of Repository?
explain the methodology of Data Warehousing?(Polaries)
Explain about hash partitioning?
how many maximum session supports to multiload in teradata ??
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
what is the difference between cardinality and Nullability?
What are your responsibilities as an etl tester?
Give the benefits of data integration suite?
what happens if the info.server doesn't find the session parameter in the parameter file?
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
how do u identify the changed records in operational data?
What is data cleaning?
What is the difference between project backlog and product backlog?
