I have read some very useful documents found in this forum.
Still I have some questions :
1. If I use datasource of a query and execute a routine to delete certain data and then write the remaining data to a DSO, there are 2 options to write the Direct Update DSO or Transactional DSO.
Option 1 is Delete All data existing in DSO before writing.
Option 2 is Delete subarea before writing.
I think Option 2 is for scenario with 2 sources.
Option 1 seems that there is no way to keep existing records not found in resulting dataset that is to be written to the DSO.
Is there a way to make it work like a normal DSO where existing data is not deleted and only same records (same key fields) are overwritten with say changed data field values?
2. What is the purpose and usage of Grouping fields in routine source fields tab ?
3. Is reporting from APD DSO faster if DSO is Transactional DSO or Direct Update DSO ?
Thank you for reading.