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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
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