Interested to Buy Any Domain ? << Click Here >> for more details...
What is the Difference between DSS & OLTP?
- 5 Answers
- 12551 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / topstar
dss(decision support system) consist of past data and
provides analysis of that useful in decision making,where
as oltp(online transaction processing)consist of current
data.
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / srinivas
hi friends,
this is right friends , bt oltp is current data. olap
maintains historical data for analyzing purpose.. olap is
read-only data. it is denormized data . it has dimession
table ,fact table data .
it has detailed data
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / srinivas m
Hi Friends This is srinivas m,
DSS -> Decision Support System is Nothing But
OLAP -> Online Analytical Processing System
DSS or OLAP contains Historical Data..Used to make Decisions.. We cannot do any DML operations on datawarehouse.
Those were defined only for Reporting Purpose..
OLTP -> This is nothing but Our Oracle Database.. It contains Volatile Data. it will not maintain any historical data. The OLTP databases contains Current Data Only..
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / shashiall
DWH is DSS(Dicision support system),whereas, OLTP is not
DSS.
| Is This Answer Correct ? | 2 Yes | 10 No |
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is staging area?
What is CDC? How to implement CDC?
What are the advantages of using informatica as an etl tool over teradata?
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
What are different types of transformations available in informatica?
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.
i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no
What is parallel processing in informatica?
I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE
Teradata 
