The Definitive Guide to Data Quality
most of the dbOutput components contain a field: "Action on data" This can take care of your update/insert logic.
you can use a tFilterRow or a tMap output filter to separate out NULL rows.
if you are generating your keys with sequences/autoincrement, you can insert child rows by using the "Additional columns" in the advanced settings of your DB output.
Watch the recorded webinar!
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.