Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between OLTP and ODS?
- 4 Answers
- 27564 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 |
why do we go for update strategy tr in SCD rather using the session properties?
.prm wirh repalce .txt is possible?
In ur current projectu have done any performance tuning of mappings?
i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time
What is synonym?
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
in oracle write query yourname+1 from dual
Is stop and abort are same in informatica?
if i am having 10 records in source, i want 20 records in target...how will you do it
Is it possible to have "5 source & 5 Target" in single mapping?
How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?
IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????
Teradata 
