Skip to Content
0
Former Member
Jan 25, 2017 at 10:35 AM

BODS Delta Job Issue

192 Views Last edit Jan 25, 2017 at 10:38 AM 2 rev

Hi All,

I have an issue facing in bods delta load.

I have job in production for both full load and delta load.

I got requirement to do filters in one data flow and I have done in where condition.

I am doing full load changing parameter in script for 60 days.

$START = sysdate () - num_to_interval(60, 'D');

Once the full load job is successful, we are changing the parameter in the same job to 15 days and activating the scheduler to run for every 1 hour.

$START = sysdate () - num_to_interval(15, 'D');

Example: full load starts from 24-Nov-2016 and loads till 23-Jan-2017.

For delta when I changed parameter to 15..it will take date from 10-Jan-2017 but when loading delta I am getting integrity constraint violation error in data flow.

Before the filters applied once the full load job is successful and used to change parameter to 15 for delta and I was activating the scheduler to run accordingly.It was working fine.

After my change in filters when I am performing the same , it gives the error :(

Thanks in advance for help..Suggest me on this..!!