Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI 12c - Disable Keep Log History (days)

kovarApr 3 2018 — edited Apr 3 2018

Hi everyone!

Is there a way to disable this feature?

load plan keep log history.png

I have a variable in this Load Plan that does the following:

SELECT

max(i_lp_inst)

FROM

odi_repo.snp_lpi_run where status = 'W' and load_plan_name = 'EXAMPLE';

The value is used for a column on my dimension that is ment to be loaded. The problem is that after 7 days, the value in this variable is deleted (?)

Can this be disabled or is it better to create my own table that will store all Load Plan execution logs?

Thanks in advance,

- Kovar

This post has been answered by Adrian_Popescu-Oracle on Apr 3 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 1 2018
Added on Apr 3 2018
3 comments
964 views