what is the difference between OLTP database and data
warehousing database?
- 4 Answers
- 6072 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 tracing level?
how would u estimate the size of Lookup transform data and index cache?
when will use SQL override in a lookup transformation?
What are cubes and olap cubes?
Explain the use lookup tables and Aggregate tables?
Can u access a repository created in previous version of Informatica?
how do u extract data from different data sources explain with an example?
Compare etl & elt?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
how would u estimate the size of Aggregator transform data and index cache?
if i have a query as flat file how can we load data to target table
State the differences between shortcut and reusable transformation
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
Mention few test cases and explain them?
What are the names of the layers in etl?
