What is the Difference between DSS & OLTP?
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 lookup chache?
How do you do error handling in Informatica?
how can we run workflow with pmcmd?
in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?
When to use normalization transformation other than cobol source?
Explain Dataware house architecture .how data flow from intial to end?
Consider a Phone Log table as below. It records all phone numbers that we dial in a given day. SOURCE_PHONE_NUMBER DESTINATION_PHONE_NUMBER CALL_START_DATETIME 1234 4567 01/07/2011 10:00 1234 2345 01/07/2011 11:00 1234 3456 01/07/2011 12:00 1234 3456 01/07/2011 13:00 1234 4567 01/07/2011 15:00 1222 7890 01/07/2011 10:00 1222 7680 01/07/2011 12:00 1222 2345 01/07/2011 13:00 Please provide an SQL query to display the source_phone_number and a flag where the flag needs to be set to Y if first called number and last called number are the same and N if the first called number and last called number are different. Desired Output: Source Number Is_Match 1222 N 1234 Y
what is incremental data aggregation?
What are the restrictions of union transformation?
What is the difference between SOURCE and TARGET BASED COMMITS?
What are the joiner caches?
What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?