what is the difference between OLTP database and data
warehousing database?
- 3 Answers
- 5882 Views
- I also Faced
- E-Mail Answers
Answer Posted / parvar
The main difference between oltp and dw are,
Oltp dw
1 current data historical data
2 normalized data de-normalized data
3 small database large database
4 application-oriented subject-oriented
5 row by row loading bulk loading the data
The data
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
what is an ETL or ETT? And what are the different types?
Difference between flat files and relational sources?
What is grain of fact?
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
what is the use of server manager?
What is etl process? How many steps etl contains?
When do we analyze the tables? How do we do it?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
What is partitioning? Explain different types of partitioning?
What is abap? What are idocs?
Identifying the bottlenecks in various components of Informatica and resolving them.
what is pmrep command?
Identifying the bottlenecks in various components of Informatica and resolving them.
What is the difference between round-robin partitioning and hash partitioning?
