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 two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression

3 Answers  

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

4 Answers   iGate,

What are ETL Tools?

0 Answers   Informatica,

tell me the informatica architecture

1 Answers   Banca Sella, Wipro,

What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?

2 Answers  

To achieve the session partition what r the necessary tasks u have to do?

1 Answers  

Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance

1 Answers  

Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you

6 Answers  

how to join the two flatfiles using the joiner t/r if there is no matching port?

5 Answers   Cegedim,

why do we go for update strategy tr in SCD rather using the session properties?

3 Answers   IBM,

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

7 Answers   Target,

can anyone explain me about sales project in informatica?

8 Answers   MBT, Satyam,