I appreciate the offer.  I actually created a small job that splits the "," delimited string of ids for each person and appends them to a globalMap ArrayList variable.  Then, I used a rowGenerator to create rows for each variable in the globalMap arraylist.  Each row has an incremented integer column, the string person-org id from the array, and a blank id column.  A JavaRow object sets the long id to the string value.  I can use that id to map the person-org tables via the ids and deactivate them.  Once I got the GlobalMap arraylist working, the rest was pretty straightforward. 

But, I never did find a way to directly map a list to a long   That would be cool to do but also potentially dangerous.

The scenario I am dealing with now is a Person record that has a link to a Person-Org record.  So, the Person record has a column that is returned in Talend as a list of foreign keys to the Person-Org table.  That's great.  In order to deactivate the Person record the job must deactivate the Person-org entries first. 

How can I map a list of ids to the primary id key in the Person-Org table?  TMap won't allow me to do that and using an iteration of some kind is proving to be problematic.

Thank you,