I am trying to move data from a oracle table to its archive table using talend. In tOracleInput component, i have included the query which fetches the data to be archived. I am moving data which are older than 2 months to archive based on date column in parent table. In child table, data is moved by linking parent table with foreign key relationship and and based on date. If i execute the query in sql developer data is fetching. Same query is used in talend, but it is not fetching data and job runs with no error. if i remove where condition it is fetching data in talend.
@Rathesh,can you make sure are you pointing to right DB? and also check that the same query are you used in Talend where in SQL was giving the output?
Could you please share the component screen shots (basic and advanced) and also the query you are executing in Talend?
Another query is whether you are using same user id while fetching data using SQL developer and Talend.
Could you please share the screen shot of your job and the component where you are getting the error? If you could share the error message it will help to narrow down the possibilities.
I doubt the error has anything to do with version 7.1. Did you find any pattern when the data is not getting loaded? Is it something like waiting for any commit to happen from previous transaction?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema