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 

1 ACCEPTED SOLUTION

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.

6 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

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