write optimized, direct , standard dso

[Former Member]

hi,

     plz tell me in which scenario we will use write optimized dso, direct dso, standard dso??? and the exact difference between all of the 

note:don't tell that standard have 3 tables,direct and write op are having 1 table

[Former Member]

Hi

You will get this information if you can able to google it.

Standard DSO: As we all know it has change log table which maintains delta records(changed/New) properly so that we can correctly update the data to further data targets.

Standard DSO is used in most of the data flows where data staging is required before you apply business rules and update it to the target.

Write Optimized DSO: This is used for data backup(Corporate memory) or if you have to handle with large data sets because it does not require data activation.

Direct Update DSO: This DSO has read and write functionality. This will be useful mostly in APD (Analysis Process Designer) or for RDA where you have to write data into tables and read the data to load it to further targets.

Regards,

Venkatesh