Hi everyone!
Is there a way to disable this feature?

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