" /> How to delete chunk in ODS? - Genesys CTI User Forum

Author Topic: How to delete chunk in ODS?  (Read 4777 times)

robig

  • Guest
How to delete chunk in ODS?
« on: May 18, 2007, 10:33:15 AM »
Advertisement
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

  • Guest
Re: How to delete chunk in ODS?
« Reply #1 on: May 18, 2007, 01:01:32 PM »
  • Best Answer
  • 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

    Offline catanirex

    • Sr. Member
    • ****
    • Posts: 272
    • Karma: 11
    Re: How to delete chunk in ODS?
    « Reply #2 on: May 21, 2007, 05:10:42 PM »
  • Best Answer
  • 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.
    « Last Edit: May 30, 2007, 12:44:11 PM by Tony Tillyer »

    robig

    • Guest
    Re: How to delete chunk in ODS?
    « Reply #3 on: May 25, 2007, 06:32:26 AM »
  • Best Answer
  • OK Thanks a lot!

    tony

    • Guest
    Re: How to delete chunk in ODS?
    « Reply #4 on: May 28, 2007, 09:14:47 AM »
  • Best Answer
  • robig - could you please indicate which response (if any) was the solution to your question? Just so's [i]we[/i] know...  ;D

    jiggazar

    • Guest
    Re: How to delete chunk in ODS?
    « Reply #5 on: May 29, 2007, 10:09:06 AM »
  • Best Answer
  • Ok! Sorry ;). The answer of catarinex