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
33444 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 is the use of the info area in the sap bw system?

0 Answers

What are the enhancements available for LIS?

1 Answers

what is L_S_RANGE?

1 Answers

What is virtual info cube with services?

2 Answers

What is a number range object?

0 Answers

When you create a datasource some flags are attached for each filed; what are they?

1 Answers

what is a multiprovider? what are the uses and in which case supposed to be use? difference between bi7.0/bw3.5?

0 Answers

What are the aggregation options for key figures?

2 Answers

What is Cell Definition ?

1 Answers Satyam,

You have 3 cube for which you create multiprovider and a report. The data doesn't show up in the report. What went wrong?

0 Answers

what is meant by safety upper limit and safety lower limit in all the deltas tell me one by one for time stamp, calender day and numberic pointer?

0 Answers Rockwell, TCS,

What is the use of real-time infocube? How do you enter data in real-time infocubes?

0 Answers

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