BODS template table issue affecting delta jobs

[Former Member]

Hi Team,

For me Full load and delta both are of same job just we are changing the days parameter in script of bods.

I had requirement of to do some filters for 2 columns in bods and added in where condition of the job, I executed the job of full load and executed successfully.

Later I changed the the days to 10 and started delta loads, where the jobs are failing continuously whole day in Production.

I got error for template table.capture.png

[Former Member]

Your help will be great to me..!!

[Former Member]

Hi Arun,

Thanks for your response.

Yes, we are using global variable for delta load.We have written script $Startday = sysdate () - num_to_interval(10, 'D').

We are doing source based delta.

Actually we are not using the template table anywhere in job..currently we have removed it and doing workaround on the execution of job.

Will do posts if find any issues. Thanks again 🙂

[former_member198401]

The error doesnt give much information.

Are you using any Global Variable to populate the Delta Date?

Can you tell me how are you doing delta(Source Based delta or Target Table based delta)?

If you want to compare the data between Source and target then you can go for Table Comparison . The final table which you are using for table Comparison should be a Target Table and not a template table.

Below Approach should work fine

Source>Query Transform(with delta Condition e.g Change_DATE>= $G_Delta_Date)> Table_Comparison(Input Primary Keys & Compare Columns defined based on requirement)>Target Table

Also post the screenshot of the Data flow which you are using.

Regards

Arun Sasi