Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between OLTP database and data
warehousing database?
- 4 Answers
- 7531 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
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
When do we analyze the tables?
list and discuss two approaches for updation of target table in Informatica and how they are different.
what is pmrep command?
where we cannot use sorter Transformation. if we use then we will not get correct data?
how do u extract data from different data sources explain with an example?
What is a materialized view log?
what is session partitioning?
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 is lookup table in etl testing?
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
Explain different types of partitioning?
explain the methodology of Data Warehousing?(Polaries)
Define slowly changing dimensions (SCD)?
Explain the difference between etl tool and olap tools?
