Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between OLTP database and data
warehousing database?
- 4 Answers
- 7649 Views
- I also Faced
- E-Mail Answers
Answer Posted / srinivas
OLTP(ONLINE TRANSACTION PROCESSING SYSTEM):
1. It is used for transaction processing.
2. tables and joins are complex.
3. entity relation models will use.
4. used for write operations.
5. performance is low.
OLAP(ONLINE ANALATYCIAL PROCESSING SYSTEM):
1. It is used for analytacial prcessing.
2. tables and joins are simple.
3. dimension modeling will use.
4. used only for read operations.
5. performance is high.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the difference between cardinality and Nullability?
what is the use of structures?how many nodes can u create in a structure?
how do u handle performance issues in Informatica . where can u monitor the performance ?
Explain different types of partitioning?
how do u set partition points in the mapping?
what are the data modeling tools you have used?(polaris)
what is data modeling?
how do u implement configuration management in Informatica?
how would u estimate the size of Lookup transform data and index cache?
Explain about enterprise scalability and roi of data integration suite?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
dimension object created in oracle can be imported in designer?how?
what is the meaning of upgradation of Repository?
Do we need an etl tool?
