No Data in Oracle table lookup

Highlighted
Five Stars

No Data in Oracle table lookup

Hi,

I am not getting any data in one of the Oracle table(in DB we have records) used as look-up for my tMap. 

I am using text file as  a source and looking up one column in one of the small oracle table to get the desc to write on target oracle table.

I verified in the properties of the tOracleInput transformation which used as lookup but no luck. all property attributes are correct.

 

can you help/guide for this.

 

/As 


Accepted Solutions
Five Stars

Re: No Data in Oracle table lookup

Thanks to all of you for your inputs.

Its fixed just by refreshing the table.


All Replies

Re: No Data in Oracle table lookup

Hi AmarS,

 

create a new job or update your current in a way that it only has 2 components (tOracleinput, tlogrow ).

 

That way make sure you get any result from your lookup.

 

BR Bp

Fifteen Stars TRF
Fifteen Stars

Re: No Data in Oracle table lookup

Hi,
Share your job design, tOracleInput and tMap settings.

TRF
Five Stars

Re: No Data in Oracle table lookup

I want to do the lookup to another oracle table, by using tlogrow is it possible ?

Five Stars

Re: No Data in Oracle table lookup

tOracleInput- It reads a table having only 21 rows.

tMap- It just doing join condition between a text file.col1 = tOracleInput.col1 and fetching the columns.

 

While running tOracleInput does not fetch any records while it exists in database.

Re: No Data in Oracle table lookup

Please share your job design and the settings to enable others to help you better.

 

What you want to achive is basic functionality. 

 

BR Bp

 

Five Stars

Re: No Data in Oracle table lookup

Thanks to all of you for your inputs.

Its fixed just by refreshing the table.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

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

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch