Question:
We use an ODS to collect records from an extractor. For business reasons we run the extractor several times per month with a full load. Since this ODS is growing fast I would like to compress it like keeping the last load per month.
How would I be able to do this?
Answer:
If you want to consistently delete the previous month's data from ODS, the best way to do is to change the existing info package. In the data targets tab there is a field "Automatic Loading ......" choose this and you will get a popup "Deleting request from info cube after update". Select the request selection thru routine and write a small routine which would select the requests based on the dates . (Requests can be found in RSREQDONE).
Regards,
Answer:
bkoram > don't think this is possible for loads to an ODS ...
jansb000 > if i understand your scenario correctly, it should be enough to delete your change log data from the ODS ... go to the PSA part in the RSA1, rightclick on your ODS and choose "delete change log data"