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.
Watch the recorded webinar!
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.