topic Re: No Data in Oracle table lookup in Talend Studio

No Data in Oracle table lookup

Anonymous — Fri, 09 Mar 2018 14:13:08 GMT

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

Anonymous — Fri, 09 Mar 2018 15:27:08 GMT

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

TRF — Fri, 09 Mar 2018 20:36:07 GMT

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

Anonymous — Mon, 12 Mar 2018 08:05:32 GMT

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

Anonymous — Mon, 12 Mar 2018 08:11:33 GMT

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.

Anonymous — Mon, 12 Mar 2018 08:17:43 GMT

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

Anonymous — Wed, 14 Mar 2018 14:42:47 GMT

Thanks to all of you for your inputs.

Its fixed just by refreshing the table.