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.

Answer / pichi

stupid answer it is....:(

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

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..

Answer / shashiall

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

i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

1 Answers   Thomson Reuters,

what is upstream and downstream transformation?

7 Answers  

we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.

8 Answers  

write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,

How can you define user defied event?

0 Answers  

What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  

What is the difference between a table and the materialized view?

2 Answers  

Can we call a stored procedure from a unix script which is run using command task

1 Answers   TCS,

I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 Answers  

Explain pushdown optimization and types in informatica

0 Answers   Informatica,

When do we use dynamic cache and static cache in connected and unconnected lookup transformations?

3 Answers  

What do you understand by a term domain?

0 Answers