Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between OLTP database and data
warehousing database?
- 3 Answers
- 7218 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
can cubes contain measures ?
What are your responsibilities as an etl tester?
What is Data Vault???
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?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
list and discuss two approaches for updation of target table in Informatica and how they are different.
what are the cubes developed in a sap bw project and what is the requirement for developing it?
how do u really know that paging to disk is happening while u are using a lookup transform?
Explain the use lookup tables and Aggregate tables?
What do you understand by active and passive transformations?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
how do u set partition points in the mapping?
How many steps etl contains?
What is fact? What are the types of facts?
when will use SQL override in a lookup transformation?
