BI7: "Delta Init. Extraction From..." under DTP Extraction tab?
In BI7.0 environment, we've got a DSO called ZDSO1 and it's data comes from three other DSOs called ZDSO2, ZDSO3, and ZDSO4. In another word, ZDSO2, ZDSO3, and ZDSO4 fill data to their target ZDSO1, i.e.:
ZDSO2 -> ZDSO1
ZDSO3 -> ZDSO1
ZDSO4 -> ZDSO1
Check the three DTP settings of the three DSOs to load data to ZDSO1, find under the Extraction tab of the three, there is a section called "Delta Init. Extraction From...", under this section, there are four radio buttons:
Active Table (With Archive)
Active Table (Without Archive)
Archive (Full Extraction Only)
For the DTP of ZDSO2 -> ZDSO1, the raido button of "Change Log" is checked, and for other two DTPs (from ZDSO3 and ZDSO4 to ZDSO1), the radio button of "Active Table (Without Archive)" are checked. Could any BI 7.0 expert illustrate how the section "Delta Init. Extraction From..." in DTP function and how the above radio button selections work?
Srinivas Neelam replied
DTP delta is request based delta. Same as loading from CUBE to other target.
But here we can choose from Active table or from change log table.
It depends on requirement. Depends on granularity and loading(Addition or overwite).
Its better to choose from Change log tables if data loading from DSO to target in addition mode at different aggregation levels. From active table only useful if entire data in source DSO getting refreshed every time.
Hope it Helps