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 |
In real world when do you recommend aggregate?
What is a reusable structure?
What is an exception aggregation and give an example?
What is an infopackage?
What is a template?
What is the use of transformation and how the mapping is done in bw?
What is an infocube?
Can you do any testing on ODS?
What is the archival transaction?
How would you know if a segment/segment level entry has been summarized?
iam looking for some scenarion on reporting concepts like - replacement path,customer exits, all types of variables. plese send me some important links and materials. so it will be helpful for me. thanks in advance
Can you name a few important tasks which are essential in the data warehousing and management of the same?