What is the difference between OLTP and ODS?

Answer Posted / edh

I've got a web application used for creating product orders
backed by an RDBMS.

The RDBMS contains the necessary tables to store the facts
(orders and orderlines) and reference data (product, vendor,
price, customer, ...).

The RDBMS is ever growing. That is, there's no cleanup of
"old" records (e.g. orders from x years back).

What kind of database is this and why ?
An OLTP, an OLAP, an ODS, ..., something else ?


Please advise.

EDH

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between Data and Index Caches?

662


Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1539


What are the different clients of powercenter?

602


What is native users?

725


What is powercenter on grid?

699






Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

560


How might you approve all mappings in the archive all the while?

602


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

1760


What is informatica?

686


Target increases every day even though no new record was inserted

1111


How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

697


I have a flat file, want to reverse the contents of the flat file

698


What is blocking transformation?

722


Explain lookup transformation source types in informatica

702


What is meant by active and passive transformation?

587