Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between OLTP database and data
warehousing database?
- 4 Answers
- 7509 Views
- I also Faced
- E-Mail Answers
Answer Posted / jteo
OLTP (Online Transaction Processing) database design is
normalised, which means it is optimized for INSERT, UPDATE.
Data warehouse design is not normalised but follows
dimensional modelling rules. They involve building star
schemas made up of fact tables and dimension tables and are
optimized for querying (SELECT).
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What do you understand by the term ‘transformation’?
what is data modeling?
Explain do we need an etl tool? When do we go for the tools in the market?
how do u really know that paging to disk is happening while u are using a lookup transform?
where is the cache (lookup, index) created and how can you see it.
what is the use of server?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
What is a materialized view log?
what are the concerns of OLTP and DSS systems?
what is the difference between cubes and package in cognos
What is virtual Data Warehousing?
can cubes contain measures ?
what make u disappointmnets in u r career
where are the log files generally stored.Can you change the path of the file.what can the path be?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
