(1) Created a SQL view that inner join multiple tables from two different database servers with where conditions. Which Transformer will be the simplest to mimic the SQL inner join? There are SQL Executor, FeatureJoiner, FeatureMerger etc. Not sure which one to use.
(2) Once I import those data into the destination SQL table, how can I also apply logic to also update another log table with each line item details (Trx ID, Name, Amount etc.)
(3) The import should also validate against the Trx ID in log table (from 2) to make sure there's no duplication trying to import again.
Still new to FME. Really appreciate for your advice.
Thanks
R