what is the differences between standard DSO and write
optimised DSO and Direct update DSO.
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What is table partition?
What is a free characteristic?
How is an Extended star schema of BW more advantageous than the star schema?
When is SID created? When is DIM ID created?
What is the top transaction for extraction?
How do you delete query objects (like workbooks, etc.,) in a single transaction?
What is data ware-housing hierarchy?
when do we use infocube and ODS??? (scenario)
I want to know about DTP in bi 7.
1.what is exception aggregation? 2.difference between condition and filter 3.difference between direct update dso and write optimized dso? 4.difference between repeat and repair process types? 5. disadvantage due to numeric pointer in generic extraction?
What is the t-code for query monitor?
What is the web download scheduler?