Data not fetching in tOracleInput component

Five Stars

Data not fetching in tOracleInput component

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.

Thirteen Stars

Re: Data not fetching in tOracleInput component

@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?

Manohar B
Employee

Re: Data not fetching in tOracleInput component

Hi,

 

    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.

 

Warm Regards,

 

Nikhil Thampi

 

 


Warm Regards,
Nikhil Thampi
Please appreciate our members by giving Kudos for spending their time for your query. If your query is answered, please mark the topic as resolved :-)
Highlighted
Five Stars

Re: Data not fetching in tOracleInput component

I don't know what is happening in talend 7.1. Sometimes it is fetching and sometimes not.

Employee

Re: Data not fetching in tOracleInput component

Hi Rathesh,

 

       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?

 

Warm Regards,

 

Nikhil Thampi


Warm Regards,
Nikhil Thampi
Please appreciate our members by giving Kudos for spending their time for your query. If your query is answered, please mark the topic as resolved :-)

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.