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

Which transformation should we use to normalise the COBOL and relational sources?

746


Explain about cumulative Sum or moving sum?

622


server hot-ws270 is connect to Repository B. What does it mean?

1855


What are session parameters ? How do you set them?

1377


What is olap (on-line analytical processing?

641






How many input parameters can exist in an unconnected lookup?

992


How to call shell scripts from informatica?

577


What is parallel processing in informatica?

1031


what are factless facts? And in which scenario will you use such kinds of fact tables.

1317


What do mean by local and global repository?

705


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1501


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9166


In how many ways we can create ports?

702


Explain informatica architecture - version 8 / 9

669


What happens to map if we alter the datatypes between source and its corresponding source qualifier?

603