Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between OLTP database and data
warehousing database?
- 4 Answers
- 7524 Views
- I also Faced
- E-Mail Answers
Answer Posted / kaki
OLTP
1. Normalized database; having lot of joins. Hence, slow
2. INSERT, UPDATE, DELETE immediately refelects data in the
OLTP transactional database.
OLAP
2. Denormalized database; having lesser joins. Hence,
performance is good.
3. Need a tool like ETL to populate the database; Data may
not be seen immediately after creation unless ETL populates
it.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what do u do when DB time takes more?in sap bi
how do u implement configuration management in Informatica?
How etl testing is different from database testing?
Explain do we need an etl tool? When do we go for the tools in the market?
what is data modeling?
What is etl process? How many steps etl contains?
What are the ETL Testing Operations?
can cubes contain measures ?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
What is cube grouping?
what are the session parameters? How do u set them?
What is tracing level?
What is tracing level and what are the types?
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?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
