Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

What differs when we choose the sorted input for aggregator transformation?

1004


Plz can any one say me how to get the informatica certification materials and dumps

2030


Could you explain what is enterprise data warehouse?

1116


Explain why we use partitioning the session in informatica?

1068


Explain what are the different types of transformation available in informatica.

1117


What is the benefit of partitioning a session?

1158


update strategy transformation in informatica

1047


Is it possible to use a client with different version than that of its Informatica server?

1119


How to generate sequence numbers?

1070


What is enterprise data warehousing?

1026


What is lookup change?

1030


Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1260


Partition, what happens if the specified key range is shorter and longer

2481


Informatica settings are available in which file?

975


Does an informatica transformation support only aggregate expressions?

1018