No Data in Oracle table lookup

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.

View solution in original post


All Replies
Highlighted

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

Sixteen Stars TRF
Sixteen 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.

View solution in original post

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog