Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between OLTP and ODS?
- 4 Answers
- 27809 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 |
how can one eliminate dupliacte data with out using distinct option?
What is the sequence generator transformation in informatica?
how to join two flat files in informatica?
without using emailtask how will send a mail from informatica?
wt is informatica file watch timers in aflat i want to get the first record and last record how could i.
I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?
In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How will you convert rows into columns or columns into rows
Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?
in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna
what is the -ve test case in your project.
PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U
Teradata 
