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.
Solved! Go to Solution.
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.
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.
Please share your job design and the settings to enable others to help you better.
What you want to achive is basic functionality.