Using 0RECORDMODE for Delta Load - SAP BW

we loaded data first into the ODS object,and then into the InfoCube. The data in the InfoCube came from an initial loading process (Screen). Now let's see how ODS uses the characteristic 0RECORDMODE values—X,D,and R—to control consequent delta loading processes.

You use 0RECORDMODE value X to mark rows to be skipped in the delta data load. You use D and R to delete or remove rows,respectively,from the active ODS table if the rows can be identified by the table primary key. Otherwise,D and R work just like X—they do not affect either the change log or the active data table.

Now let's illustrate how the ODS delta load works.
Table lists the first four rows of the original sales data from Table. What happens to the data in the ODS object and the InfoCube after loading the Table data into them? Table has an extra column that contains the 0RECORDMODE values. Also,the sales quantity is doubled.

FIRST FOUR ROWS OF THE ORIGINAL DATA BEFORE CHANGES
FIRST FOUR ROWS OF THE ORIGINAL DATA BEFORE CHANGES

FIRST FOUR ROWS OF THE DATA AFTER CHANGES
FIRST FOUR ROWS OF THE DATA AFTER CHANGES

Repeating the procedure outlined in Section for loading data into the ODS object,we see that the PSA data in Screen match the data in Table. This result is expected.
Maintenance of PSA data request

After loading the PSA data into the ODS object,the table /BIC/AODS_DEMO10 contains the new data (Screen). The second row of Table does not appear here,which indicates that BW detected the value X in the 0RECORDMODE column and then skipped the second row.
Data browser

After activating the ODS data,Screen shows that four rows are appended to the end of the change log table,/BIC/B0000842000. The first of these rows matches the first row in Table. The remaining three rows match the first,third,and fourth rows in the table /BIC/B0000842000,except that "-" is added to the /BIC/IO_QUAN value.
Data browser

Screen shows the active data in the table /BIC/AODS_DEMO00. This result comes from compressing the change log; that is,the "-" sign actually makes the number on its left negative,and the result of the compression deleted the first,third,fourth,and last three rows from the change log.
Data browser

Now we load the ODS data into the InfoCube as shown in Screen. This time we select the Delta Update option.
Update ODS table

BW makes the corresponding selection automatically in the InfoPackage definition.
Update ODS table

After we launch the delta load process,changes to the data appear in the InfoCube fact table (Screen). Three new rows are added as another data load request. The values in the three new rows are obtained by compressing the last four rows in Screen. The "-" sign has the same meaning—it makes the number on its left negative.
data browser table

Result:
These steps prove what we said at the beginning of this section: You use 0RECORDMODE value X to mark rows to be skipped in the delta data load. You use D and R to delete or remove rows,respectively,from the active ODS table if the rows can be identified by the table primary key. Otherwise,D and R work just like X—they do not affect either the change log or the active data table.


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

SAP BW Topics