What is the Difference between DSS & OLTP?

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

Question Posted / guest

5 Answers
12635 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the Difference between DSS & OLTP?..

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

What is the Difference between DSS & OLTP?..

Answer / pichi

stupid answer it is....:(

Is This Answer Correct ?

8 Yes

2 No

What is the Difference between DSS & OLTP?..

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

What is the Difference between DSS & OLTP?..

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

What is the Difference between DSS & OLTP?..

Answer / shashiall

DWH is DSS(Dicision support system),whereas, OLTP is not
DSS.

Is This Answer Correct ?

2 Yes

10 No

Post New Answer

More Informatica Interview Questions

when i try to connect to the repository server i am getting this message can someone help me.. Starting Repository [infa_rep] (6016|1292) Informatica Repository Agent, version [7.1.1], build [0811], 32-bit. (6016|1292) Copyright (c) 2000-2004 Informatica Corporation. All Rights Reserved. This Software is protected by U.S. Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158; 5,794,246; 6,339,775 and other U.S. Patents Pending. (6016|1292) Informatica Repository Agent starting up. (6016|1292) Security audit trail has been turned off. (6016|1292) infa_rep: Repository runtime manager initialized. (6016|1292) infa_rep: Initialized configuration information. (6016|1292) infa_rep: Initialized request dispatcher. (6016|1292) Database Connection Error : Failed to logon to Database server ORA-12154: TNS:could not resolve service name Database driver error... Function Name : Connect Database Error: Failed to connect to database using user [] and connection string []. (6016|1292) Service stopped.

1 Answers

what is mystery dimension?

1 Answers

Without source how to insert record to target?

6 Answers

What is meant by LDAP users?

0 Answers

What is the need of building a data warehouse?

2 Answers

What is the way to execute pl/sql script using informatica mapping?

0 Answers

What is an Integration service in Informatica?

0 Answers

in realtime which situations u can use unconnected lookup transformation

2 Answers Patni,

can we override a native sql query within informatica? How do we do it?

0 Answers

LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?

6 Answers

1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),

10 Answers Cap Gemini,

1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers CompuSoft, EDS, TCS,

For more Informatica Interview Questions Click Here