Skip to Content
avatar image
Former Member

BODS template table issue affecting delta jobs

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • 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.

    Regards

    Arun Sasi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    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 :)

    Add comment
    10|10000 characters needed characters exceeded