Interested to Buy Any Domain ? << Click Here >> for more details...
What is the Difference between DSS & OLTP?
- 5 Answers
- 12801 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 |
what is normalization? explain 1st NF, 2nd NF, 3rd NF
How can you validate all mappings in the repository simultaneously?
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
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
How do you implement configuration management in Informatica?
how to create user defined function (udf) in informatica
in realtime which situations u can use unconnected lookup transformation
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
What is source qualifier transformation?
i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...
How to go to the older version for a mapping?
What are steps to follow Informatica migration from 7x to 8x? Pls Explain...
Teradata 
