Skip to Content

BODS template table issue affecting delta jobs

Jan 24, 2017 at 09:18 AM


avatar image

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

capture.png (6.7 kB)
10 |10000 characters needed characters left characters exceeded

Your help will be great to me..!!

* Please Login or Register to Answer, Follow or Comment.

2 Answers

Arun Sasi Jan 24, 2017 at 10:49 AM

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.


Arun Sasi

10 |10000 characters needed characters left characters exceeded
N Neeluri Jan 24, 2017 at 02:18 PM

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 :)

10 |10000 characters needed characters left characters exceeded