Miserable ODS changelog table

I recently made a mistake and was impressed with changelog, which is summarized as follows:

1. For the data source generated by ODS (the data source starting with 8), the PSA is the changelog table of ODS, so it will be automatically loaded without creating an information package.

2. If you delete the request from this data source, in ODS, the changelog of the request will be deleted accordingly.

 

Next we will summarize the consequences of deleting changelog.

1. This ODS request can no longer be deleted, because the Delete request is based on changelog table.

2. The ODS request could no longer reach the upper-layer cube, because the Delta loading references changelog table.

3. Even if the data in this ODS request is full to ODS, Delta cannot be loaded to the upper cube, because the data is still in Table, the changelog of the new request is generated based on table.

 

The conclusion is that the premise of deleting changelog is that all data has been updated to Delta, otherwise it will have to use full.

 

If you delete it accidentally, the solution is as follows:

Choose to delete the cube data and load the data in full mode.