ODI SNP tables data getting purged

Question

Hi,

ODI SNPtables are getting purged automatically .

In BI Apps implementation ODI tables are getting purged automatically . Data is there for only 7 days.

Is there any setting which does this ??

Any pointers regarding this would be helpful

Regards,

Mahesh

841717 · Answer

I think what you're trying to say is that operator logs (stored in some SNP tables) are getting purged every 7 days. Correct me if I'm wrong.

To retain logs for a longer time, open the generated (or predefined) load plan and set "Keep Log History (Days)" to a higher number. Note that since you're retaining logs for a longer time, your SNP log table will grow to a great extent (as each LP execution produces a ton of log). So make sure the number is high enough to fulfill your needs but not very large so that it does not become a storage overhead.

Thomas Dodds · Answer

Check configuration document for the snapshot dates and frequency setups.

Anjum Ara · Answer

Hi Mahesh

You can check with your system team or ODI team if they have setup automation process to purge the tables not quite possible that it does it on its own.