what is the differences between standard DSO and write optimised DSO and Direct

what is the differences between standard DSO and write
optimised DSO and Direct update DSO.

Question Posted / rajabw

3 Answers
33202 Views
CTS, Fujitsu, IBM, Infosys, Tata Technologies, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the differences between standard DSO and write optimised DSO and Direct update DSO...

Answer / viralkumar shah

Standard DataStore object
Data provided using a data transfer process
SID values can be generated
Data records with the same key are aggregated during activation
Data is available for reporting after activation.
Having three tables: chage log, new & active table.

Write-optimized DataStore object
Data provided using a data transfer process
SID values cannot be generated
Records with the same key are not aggregated
Data is available for reporting immediately after
it is loaded. It is used when you want to insert some
amount from the other application like dynapro. having two
tables
DataStore object for direct update
Data provided using APIs
SIDs cannot be generated
Records with the same key are not aggregated
Mainly used with APDs

Is This Answer Correct ?

40 Yes

2 No

what is the differences between standard DSO and write optimised DSO and Direct update DSO...

Answer / rahul kulkarni

Standard DSO provides you delta images, it has overwrite
fucntionality as well.
Write optimizes DSOs are used for efficient and targeted for
warehouse layer of the architecture.
Direct DSO is old concept (3.x), can be loaded data only
with APIs

Is This Answer Correct ?

19 Yes

10 No

what is the differences between standard DSO and write optimised DSO and Direct update DSO...

Answer / tony

Standard DSO can have one user and one operation at a time.
Write optimized DSO is used to get unique records

Is This Answer Correct ?

11 Yes

26 No

Post New Answer

More SAP BW (Business Warehouse) Interview Questions

What are the settings for data transfer?

0 Answers

What are the steps within SBIW to create classes for BW?

1 Answers

What is percentage share of result (%CT)?

1 Answers

Can you partition a cube that has data already?

5 Answers

WHAT IS THE MAIN DIFFERENCE BETWEEN INFOPACKAGE & DTP? WHAT ARE THE REPEATED TABLES WE ARE USE IN REALTIM PROJECTS? WHAT IS THE DELTA UPDATE IN LOCOCKPIT? WHAT ARE THE TABLES IN SD,FISL & MM? How to we modify the processchain running errors? what is the repeated error in realtim projects? tel me the realtime flow & hw to answer the interview level?

4 Answers TCS,

What are the versions in objects?

0 Answers

Which transaction can you use to get current statistics data?

1 Answers

When do you recommend high cardinality vs line item dimension?

2 Answers

How does the time dependency works for bw objects ?

0 Answers

How do you do EURO conversion at the database level?

0 Answers

What makes it more advanced than sap business warehouse (sap bw) 7.5?

0 Answers

Suppose, You are working on a report, how do you know from which INFOCUBE ,report should be generated ?

3 Answers Accenture,

For more SAP BW (Business Warehouse) Interview Questions Click Here