Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between OLTP database and data
warehousing database?
- 3 Answers
- 7231 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 are the reports developed in sap bw project and what is the requirement for developing it?
what are the session parameters? How do u set them?
Explain the use lookup tables and Aggregate tables?
what is the difference between cardinality and Nullability?
how to connect to a flatfile through ftp in informatica
Can u access a repository created in previous version of Informatica?
What are your responsibilities as an etl tester?
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)
What are the key benefits of ETL Testing?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
what are the concerns of OLTP and DSS systems?
What is tracing level?
what are the facilities provided by data warehouse to analytical users?
