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!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Accelerate your data lake projects with an agile approach