The Definitive Guide to Data Quality
I tried to use the the (run each rows) but it's almost loading 20 rows by second because for each rows of the mirror table TOS is refreshing the lookup table fullyl which in my case it's not usefull as I need a refresh by date (iteration).
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.