What is the Difference between DSS & OLTP?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

1789


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1673


What is meant by target load plan?

646


without table how to come first record only in oracle?

1940


Define filter transformation?

718






which one is better performance wise joiner or look up

727


Explain the types of transformations?

689


How to generate sequence numbers using expression transformation?

729


How to convert multiple rows to single row (multiple columns) in informatica

1017


What is pmcmd command?

769


What is source qualifier transformation in informatica?

647


What is Cognos script editor?

3867


What are data-driven sessions?

824


What is the function of aggregator transformation?

667


What is rank transformation in informatica

801