Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between OLTP database and data
warehousing database?
- 4 Answers
- 7647 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
Explain about round-robi?
can cubes contain measures ?
what is the difference between cubes and package in cognos
How etl testing is different from database testing?
What is lookup table in etl testing?
What are the steps involved in etl process?
what is Forward,Reverse and Re_engineering?
What is virtual Data Warehousing?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
What are various etl tools in the market?
Explain do we need an etl tool?
flat filevalidation in informatica
Which transformation we use to convert 'NA' to 'Not Available'
how does the server recongnise the source and target databases.Elaborate on this
What is data cleaning?
