Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between OLTP database and data
warehousing database?
- 4 Answers
- 7662 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
What are the three tiers in etl?
how do u really know that paging to disk is happening while u are using a lookup transform?
what is pmrep command?
what is pmrep command?
what is data modeling?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
List few etl bugs?
What are the steps involved in etl process?
how do u identify the changed records in operational data?
What is etl tool in hadoop?
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?
what is the meaning of upgradation of Repository?
what is different between sequential batch and concurrent batch and which is recommended and why?
how would u estimate the size of Aggregator transform data and index cache?
what is a worklet?
