Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between OLTP and ODS?
- 4 Answers
- 27829 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 |
What is confirmed fact in dataware housing?
HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?
How we can use union transformation?
Clarify the utilization of aggregator cache record?
Why we use ENABLE HIGH PRECISION in session properties?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
in oracle write query yourname+1 from dual
expain about the tune parameters?
what are types of dimentions?
What is a command that used to run a batch?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Different qualification between a related rotate toward the sky and isolates look upward?
Teradata 
