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
32177 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 process chain and when you can use the same in the data warehouse?

0 Answers

What do you mean by start routines

0 Answers

Explain multiprovider?

0 Answers

What are the steps to do the creating classes in sap-bw.

0 Answers

How do you start change run?

2 Answers

What is the monitor transaction?

1 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,

How to fetch the data from sap-r/3, sap-bw/bi to informatica system? what is step by step procedure? at what senario you retrieve the data from sap system to informatica or say dwh system? --

0 Answers Wipro,

Define an event chain?

1 Answers

what are the perameters? can u say what type of perameters regularly used?

1 Answers HCL,

1.What is exception Aggregation? give Example? 2.what Cell formating? and Advantages?

1 Answers IBM, Mind Tree,

What are the types of reports you can use in reporting agent?

0 Answers

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