I am reading from an Oracle database with a basic filter e.g. year =2019. If I use the Talend db component with a Tmap, it reads all records in(across a network) and takes forever. I know the query at the db is very fast. I'd like Talend to send the query to the database and bring in the records as they meet the criteris. How would this be accomplished?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema