Assigning Values to Context Varibales for Incremental Data load

[_AnonymousUser]

Hi,
I am new to Talend and was looking for the way, we can do incremental data load. I am using Oracle database for Source and Target. I have create Context variable with name ‘PERIOD_YEAR’ which hold year data in ‘Integer’ Data Type.
Problem Description: I am using below objects in my Job. 
[size=3]tOracleInput: To get the Max Date which get loaded into the target table using SQL[/size]
                         Select MAX(PERIOD_YEAR) from <TARGET_TABLE>
[size=3]tJavaRow: Is used to assign values to Context variable which we got from the above object ‘tOracleInput’  [/size]
[size=3]                    context.PERIOD_YEAR = input_row.PERIOD_YEAR;[/size]
Then I have remaining Objects which fetch incremental data bases on my Context Variable.
I am Getting Error at ‘tJavaRow’ step with message like ‘Type mismatch: cannot convert from BigDecimal to Integer’.
Any pointer will appreciated, Thanks for your help and support.
Regards
Saket Krishna



 

[Anonymous]

What is the data type of PERIOD_YEAR column on the schema of tOracleInput? Is it BigDecimal? Try to change it to Integer type.