Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: robig on May 18, 2007, 10:33:15 AM

Title: How to delete chunk in ODS?
Post by: robig on May 18, 2007, 10:33:15 AM

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

Title: Re: How to delete chunk in ODS?
Post by: tony on May 18, 2007, 01:01:32 PM

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

Title: Re: How to delete chunk in ODS?
Post by: catanirex on May 21, 2007, 05:10:42 PM

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.

Title: Re: How to delete chunk in ODS?
Post by: robig on May 25, 2007, 06:32:26 AM

OK Thanks a lot!

Title: Re: How to delete chunk in ODS?
Post by: tony on May 28, 2007, 09:14:47 AM

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

Title: Re: How to delete chunk in ODS?
Post by: jiggazar on May 29, 2007, 10:09:06 AM

Ok! Sorry ;). The answer of catarinex