Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between OLTP database and data
warehousing database?
- 4 Answers
- 7515 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?
how do u identify the changed records in operational data?
hoe to access second value in mapping parameter if it is having more than one value ?????????????
Explain different types of partitioning?
what is pmrep command?
Explain what are the various etl tools in the market?
Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in
Difference between flat files and relational sources?
Identifying the bottlenecks in various components of Informatica and resolving them.
What is a lookup table in etl?
what are the reports developed in sap bw project and what is the requirement for developing it?
what is the difference between cubes and package in cognos
what is the use of server?
Can we create Hierarchies in generic datasources?
What are the differences between sql override and update override?
