Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between OLTP and ODS?
- 4 Answers
- 27645 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mohit sondhi
OLTP is online transaction processing systems and ODS os
operational database system.
In OLTP we can save the current data, it depends on the day
to day transactions and it stores the day to day data.
In ODS we can store data for a month also and it is not
restricted to a specific day or transaction.
| Is This Answer Correct ? | 16 Yes | 6 No |
Answer / himanshu
OLTP : Online Transaction Processing
The granularity of the data is Transaction i.e. stores each
transaction.
ODS: Operational Data Store
As dataware house contains summarized data
(Weekly/Monthly/Yearly). ODS may be used to maintain data
with lower granilarity (Hourly/Daily).
eg. Data for previous years may be summarized but sould not
be for the current year.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / 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 |
Answer / sri47
OLTP refers a transactional Data base.
ODS refers a data base which actually contains the Basic
data like the details of available Procts,and Branches of
Company etc.
Means It will be small in size and can be modified
daily.Most of the times Thos ODs is used for loading the
Dimensions.
| Is This Answer Correct ? | 1 Yes | 5 No |
If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.
what is index?how it can work in informatica
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
without update strategy how to insert &update?
when we go for unconnected lookup transformation? and why?
Whats the difference between informatica powercenter server, repositoryserver and repository?
How to convert IBM Cognos generated XML to a readable XML format for ETL tools
how to return multiple columes through through un-connect lookup?
which transformation uses cache?
What are the mapping parameters and mapping variables?
Can we create a Integration service without a Repository service and vice versa?
Without using any transformations how u can load the data into target?
Teradata 
