How to delete chunk in ODS?

[robig]

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

[tony]

I [i]think [/i] 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 [i]right[/i]-click with the mouse - then select [b]Edit[/b] 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

[catanirex]

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.

[robig]

OK Thanks a lot!

[tony]

robig - could you please indicate which response (if any) was the solution to your question? Just so's [i]we[/i] know... 

[jiggazar]

Ok! Sorry . The answer of catarinex