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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables