No Data in Oracle table lookup

[Anonymous]

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]

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]

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

[Anonymous]

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

[Anonymous]

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]

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 · Accepted solution]

Thanks to all of you for your inputs.

Its fixed just by refreshing the table.