How to delete chunk in ODS?

General Discussion
1

Hi y’all! At the time ETL service delete from ODS table every 10 days, but how can i configure this period?

Thanks a lot

2

I think you are referring to data Purging in ETL Assistant?

Open ETL Assistant, Select a Layout/Aggregation Level. Whilst selected, hover your pointer over the Layout Name and right-click with the mouse - then select Edit from the dropdown-menu. You should then be able to set retention and purging rules for your data, on the right-hand-side of the screen.

Is that what you meant?

Tony

3

Hi,

Do you mean when the option dropTransferredTables are used to drop the OL_DATA_xxx table?
ETL does not remove any data from the table - it simply drops the table when all rows are filled and transferred. Maximum row are configured i DataSourcer options. (default 1 000 000?). You can lower it to fit your needs.

5 Likes
4

OK Thanks a lot!

5

robig - could you please indicate which response (if any) was the solution to your question? Just so’s we know… ;D

6

Ok! Sorry ;). The answer of catarinex