Pentaho: Kettle/Spoon: Combining multiple data after inserts -


i'm using pentaho's kettle/spoon load customer. can't figure out how join 2 or more transformations after they're complete

     source   /    |     \      |      b   \    |     /    insert data  (database alpha) source data  id, name, ssn, email, cancall, emailstatus  (database beta)  a) inserts email status table if doesn't exist returns id b) inserts pii table if doesn't exist returns id insert data  emailstatustable 1, can_email 2, can_not_email  pii table 1, "johnson, john", "todays_date" 2, "jackson, jillian", "todays_date"  customertable 1, 1 (pii table id), "jjohnson@blah.com", true (can call), 1 (email status table id)  2, 2 (pii table id), "jill_jack@home.com", false (can call), 2 (email status table id) 

i can't figure out how make "insert data" portion work. please.

combination lookup/update

step solve problem easily

enter image description here


Comments

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

vue.js - Create hooks for automated testing -

Add new key value to json node in java -