what is the difference between OLTP database and data
warehousing database?
- 3 Answers
- 5900 Views
- I also Faced
- E-Mail Answers
Answer Posted / murthy
The main deference between them is
OLTP:used to store current transaction data not large
historical data(ex:bank ATM)
DWH:
used to store historical data aruond 3-6 years.
apart this include the standara differences
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
flat filevalidation in informatica
what are the cubes developed in a sap bw project and what is the requirement for developing it?
What is fact? What are the types of facts?
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
How can we use external procedural logic in informatica?
Mention few test cases and explain them?
What is grain of fact?
What are the different Lookup methods used in Informatica?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
What is abap? What are idocs?
what are the concerns of OLTP and DSS systems?
Explain and compare etl & manual development?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
